How to Filter Groups with HAVING in Oracle SQL
Keep only the groups you need by filtering on counts, sums, and other aggregates, and learn when a condition belongs in WHERE instead.
AI-Assisted
Posts tagged AI-Assisted are created with support from artificial intelligence. I use AI tools to research, draft, and refine ideas—combining human insight with machine precision to deliver clear, informed, and creative content.
How to Install Oracle AI Database 26ai Free on Windows
Check the prerequisites, run the Windows installer interactively or silently, and connect to the FREE container database and FREEPDB1.
How to Install Oracle AI Database 26ai Free on Oracle Linux
Install the database from Oracle's RPM packages, create the FREE container database, connect through the listener, and start it at boot.
How to Upgrade ORDS for Oracle APEX
Install a new ORDS release next to the old one, upgrade the ORDS schema with the same configuration folder, and switch over safely.
How to Serve Several Databases from One ORDS
Add a connection pool for each database or PDB, reach each APEX instance at its own ORDS URL, and manage every pool's settings separately.
How to Deploy ORDS in Apache Tomcat for Oracle APEX
Run ORDS as a web application in Apache Tomcat instead of standalone, serve the APEX images, and see which settings move to Tomcat.
How to Enable HTTPS in ORDS for Oracle APEX
Secure Oracle APEX with HTTPS using an ORDS self-signed certificate for testing, your own certificate, or Nginx as a reverse proxy.
How to Configure ORDS for Oracle APEX
Understand how ORDS serves APEX, where its settings live, and how to change the web server and connection pool settings safely.
How to Install Oracle APEX 26.1 on macOS
Run Oracle AI Database 26ai Free in a container and ORDS natively on your Mac, with start scripts and a launchd agent that starts ORDS at login.
How to Install Oracle APEX 26.1 on Oracle Linux
Build a native Oracle APEX 26.1 server on Oracle Linux, with the database and ORDS running as systemd services that start at boot.
How to Install Oracle APEX 26.1 on Windows
Install Oracle AI Database 26ai Free, ORDS, and APEX 26.1 directly on Windows, then keep ORDS running in the background without Docker.
How to Install Oracle APEX 26.1 with Docker
Build a complete Oracle APEX 26.1 environment in about half an hour with Oracle AI Database 26ai Free in a container and ORDS on your computer.
How to Prepare Your Computer for Oracle APEX 26.1
Check requirements, install Java, a container engine, SQLcl, and VS Code, and download APEX and ORDS before installing Oracle APEX 26.1.
How to Deploy Oracle AI Applications to Production
Add a kill switch, a daily budget, and monitoring to Oracle AI Database 26ai features, and deploy everything an AI application needs to each environment.
How to Run AI Jobs in the Background with DBMS_SCHEDULER
Keep users from waiting on an AI provider by embedding and classifying new data in a DBMS_SCHEDULER job that logs its work and retries failures.
How to Reduce the Cost of LLM Calls in Oracle
Measure what language model calls cost and how fast they are from inside Oracle 26ai, then cut cost with smaller models, lean prompts, and caching.
How to Control What an AI Assistant Can See with Row-Level Security
Make internal documents invisible to customers and available to agents in a RAG assistant, with row-level security on retrieval in Oracle 26ai.
How to Defend Oracle AI Applications Against Prompt Injection
See how a planted document reaches a RAG assistant in Oracle AI Database 26ai, block it with a review gate, and build defenses in layers.