Getting to know Oracle’s AI Vector Search
Oracle’s introduction of AI Vector Search in Database 23ai brings native support for vector data types, making it easier to…
Getting to know Oracle Advanced Queuing (AQ)
DBMS_AQ is a built-in Oracle package for managing Advanced Queuing (AQ), a messaging system integrated into Oracle Database. It provides…
5-Minute Setup for Oracle Database Using Docker
Docker provides an efficient way to create and manage database environments. By leveraging containerization, DBAs can easily spin up isolated…
DBMS_PIPE, how to exchange data among different sessions.
DBMS_PIPE is an Oracle PL/SQL package that provides a mechanism for inter-process communication within the database. It allows different sessions…
Generating and Validating XML from Oracle DB.
XML (eXtensible Markup Language) is a powerful way to represent structured data in a human-readable format, and Oracle Database offers…
Connecting SQL Developer to the DB server using a SOCKSv5 SSH proxy
Using a proxy server or bastion host when connecting to an on-premise database provides several key benefits in terms of…
Understanding Metrics in Oracle 19c: A Practical Guide
Metrics in Oracle 19c provide essential insights into the performance and health of your database. By monitoring these metrics, database…
Introduction to Read-Only Materialized Views in Oracle 19c
Materialized views in Oracle 19c store query results physically, enhancing performance for complex queries and data warehouse environments. They enable…
Summary of DBMS_SCHEDULER in Oracle
DBMS_SCHEDULER is an advanced job scheduling and management package in Oracle that offers extensive features and flexibility. It is designed…
RAG with Langchain and Oracle Database – Part III Dealing with approximate spelling of proper nouns
In this part of the series, we address the challenge of dealing with approximate spellings of proper nouns. This is…