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…
RAG with Langchain and Oracle Database – Part II Providing memory to the agent.
Continuing from our previous post, we can see that the agent we defined is unable to remember our previous conversation,…
RAG with Langchain and Oracle Database
The recent arrival of Generative AI in the database world will revolutionize data interaction and utilization. These models can understand…
Backing Up Partitions Using RMAN
While RMAN (Recovery Manager) in Oracle Database does not support backing up individual partitions directly, you can effectively back up…