
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.

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.

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.

Show agents how similar tickets were solved, suggest articles, and draft replies they check and send, in Oracle APEX 26.1 with vector search.

Rank the questions your assistant could not answer by their nearest source, and let a model propose which articles to write or extend.

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.

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.

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.

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.

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.

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.

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.

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.

Use the APEX_AI package to generate text, hold conversations, get embeddings, and give a model tools, with the settings of your APEX app.

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.

Combine SQL property graphs with vector search in Oracle AI Database 26ai to find who had a similar problem and which customers it affects.

Keep embeddings inside JSON documents in Oracle AI Database 26ai and search them by meaning, in collections or through duality views.

Join, group, and count rows by meaning with VECTOR_DISTANCE in Oracle AI Database 26ai to find knowledge gaps and the right agents.

Combine Oracle Machine Learning with embeddings to classify instantly for free, hand uncertain cases to a language model, and find topics.