How to Redact Personal Data Before Calling an LLM in Oracle
Keep personal data out of prompts in Oracle AI Database 26ai with a redaction function, a call log, encrypted credentials, and tight network ACLs.
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 Run a Local LLM with Ollama from Oracle Database
Keep every prompt on your own hardware by serving a model with Ollama and calling it from Oracle AI Database 26ai, then measure what you trade.
How to Build an Ask Your Data Page in Oracle APEX
Let users ask questions about your data in plain language on an Oracle APEX 26.1 page that answers with a sentence, a table, a chart, and its SQL.
How to Build an AI Help Desk Workspace in Oracle APEX
Show agents how similar tickets were solved, suggest articles, and draft replies they check and send, in Oracle APEX 26.1 with vector search.
How to Find Knowledge Base Gaps with AI in Oracle APEX
Rank the questions your assistant could not answer by their nearest source, and let a model propose which articles to write or extend.
How to Build a Knowledge Assistant in Oracle APEX
Let customers ask questions in their own words and get cited answers on an Oracle APEX 26.1 page that records every question and its feedback.
How to Create an APEX Application from a Description with AI
Describe an application in a few sentences and let the APEX 26.1 Assistant fill in the Create App wizard, then review and correct it before building.
How to Use the APEX Assistant in SQL Commands
Let the APEX 26.1 Assistant write SQL over your schema in SQL Workshop, catch where it goes wrong, and choose the right model for the builder.
How to Build a Semantic Search Page in Oracle APEX
Let users search by meaning in Oracle APEX 26.1 with a vector provider, a vector search configuration, and a search page, without writing SQL.
How to Add AI to an Oracle APEX Form
Draft replies grounded in your knowledge base and classify records as they are saved, in an Oracle APEX 26.1 form with almost no code.
How to Build an AI Agent That Changes Data in Oracle APEX
Let an Oracle APEX 26.1 AI agent change tickets on a user's behalf, with validated arguments, approval before every change, and an audit trail.
How to Add an AI Assistant to an Oracle APEX Page
Give users a chat that answers from your knowledge base and data with an APEX 26.1 AI agent, tools, and the Show AI Assistant dynamic action.
How to Intercept AI Calls with Request Handlers in APEX
Route every AI call of an Oracle APEX 26.1 application through one PL/SQL procedure that redacts, logs, and repairs requests before they leave.
How to Call AI from PL/SQL with the APEX_AI Package
Use the APEX_AI package to generate text, hold conversations, get embeddings, and give a model tools, with the settings of your APEX app.
How to Configure Generative AI Services in Oracle APEX
Connect Oracle APEX 26.1 to Gemini or another AI provider with a Generative AI service, and set each application's AI service, consent, and handlers.
How to Rank Graph Paths by Meaning with SQL Property Graphs
Combine SQL property graphs with vector search in Oracle AI Database 26ai to find who had a similar problem and which customers it affects.
How to Store Vectors in JSON Documents in Oracle
Keep embeddings inside JSON documents in Oracle AI Database 26ai and search them by meaning, in collections or through duality views.
How to Join Tables by Meaning with Vector Search in Oracle
Join, group, and count rows by meaning with VECTOR_DISTANCE in Oracle AI Database 26ai to find knowledge gaps and the right agents.