How to Generate Embeddings in SQL with VECTOR_EMBEDDING
Embed text inside Oracle AI Database 26ai with VECTOR_EMBEDDING, keep embeddings current with a trigger, and search tickets by meaning.
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 Load an ONNX Embedding Model into Oracle Database
Run embeddings inside Oracle AI Database 26ai by loading a prebuilt ONNX model from a file or a BLOB, checking it, and managing it safely.
How to Measure Vector Distance with VECTOR_DISTANCE in Oracle
Compare vectors with VECTOR_DISTANCE in Oracle AI Database 26ai, choose the right metric, and find the nearest rows with ORDER BY and FETCH FIRST.
How to Use the VECTOR Data Type in Oracle AI Database 26ai
Store embeddings in Oracle AI Database 26ai with the right VECTOR declaration, format, and storage, and convert and inspect them in SQL and PL/SQL.
AI Concepts Explained for Oracle Developers
The few ideas behind every AI feature, from language models and tokens to embeddings, vectors, RAG, and agents, explained in database terms.
How to Call Gemini from Oracle Database with a Stored Credential
Store a Gemini API key safely as an Oracle credential, open the network to Google, and send your first prompt from SQL in Oracle AI Database 26ai.
Stop Duplicate Records from Double-Clicking Save in Oracle APEX
One Before Page Submit dynamic action disables the buttons on every page while it submits, plus an optional database safety net for critical tables.
Prevent Lost Updates in Oracle APEX: "Someone Else Changed This Record"
What APEX forms do by default, how to show a clear message, and how to protect your own PL/SQL save processes with a ROW_VERSION column.
Handle All Errors in One Place in Oracle APEX: Error Handling Function and Error Log
One table, one PL/SQL function, and one application setting give central error handling and an Error Log page for any Oracle APEX app.
Tally-Style Drill-Down Reports in Oracle APEX with Keyboard Navigation
Three levels of Classic Reports and a dialog, with one small JavaScript file for Tally-like keyboard navigation, a sticky grand total, and a Print button.
How to Track Who Changed What in Oracle APEX: A Change History for Any Table
One history table, a small package that creates the trigger for any table, and a Classic Report region that shows who changed what.
How to Make an Item Read Only in Oracle APEX Without Losing Its Value
A short, step-by-step fix for disabled form items that save as empty or fail with a required error, with a readable read-only style.
Mask Sensitive Data in Oracle APEX with Oracle Data Redaction (DBMS_REDACT)
A step-by-step guide to masking personal data by role in Oracle APEX with DBMS_REDACT, an application context, and fixes for the form and filter traps.
Row-Level Security in Oracle APEX with VPD: Show Each User Only Their Own Data
A step-by-step guide to showing each Oracle APEX user only their own rows with Virtual Private Database, one policy function, and no WHERE clauses in the pages.
How to Build Electronic Signatures in Oracle APEX: A Free DocuSign Alternative with a Digital Seal
A step-by-step guide to signing PDFs in your own Oracle APEX schema, with one-time codes, an immutable audit trail, a digital seal, and any PDF tool.
How to Deploy an Oracle Forms Application
Take a multi-form Oracle Forms 14.1.2 application from Forms Builder to users, with the compile order, files, environment, and URL it needs.
How to Structure a Multi-Form Oracle Forms Application
Organize an Oracle Forms 14.1.2 application into a library, template, menu, and forms that share the signed-in user and open each other one way.
How to Show a Record Count Before Scrolling in Oracle Forms
Count the records of a query before it runs in Oracle Forms 14.1.2 and show users where they are, without waiting for the last row to be fetched.