One-stop resource for everything related to
Oracle Database

XMLType

Understanding XMLType In Oracle Database.

XMLType is used to store and manipulate XML data. You can use XMLType to define database columns and PL/SQL variables…

RETURNING INTO

Understanding Oracle INSTEAD OF TRIGGER

INSTEAD OF triggers are essentially alternatives to DML triggers. They fire when inserts, updates, and deletes are about to occur;…

RETURNING INTO

Understanding Oracle External Tables

External tables are read-only tables that allow Oracle to query data that is stored outside the database in flat files….

RETURNING INTO

Understanding ROWID In Oracle Database

Every record has a unique ROWID (pseudocolumn) within a database representing the physical location on disk where the record lives….

RETURNING INTO

Log Sub-Program Parameter Values Using LOG4PL/SQL Framework In Oracle Database 19c

LOG4PLSQL is an open source tool that uses PL/SQL framework to log into PL/SQL code package,function,web application,procedure, trigger and various…

index_compression

Understanding Index Compression In Oracle Database 19c

From Oracle 9i onward both non-unique and unique indexes can be compressed to save disk space. The COMPRESS [N] clause…

index_compression

Understanding Difference Between Table Function & PIPELINED Table Function In Oracle Database 19c

TABLE FUNCTION A table function is a function that can be called from within the FROM clause of a query,as…

split_partition

Understanding ONLINE Split Partition In Oracle Database 12c.

In Oracle Database 12c Release 2 (12.2) the SPLIT PARTITION operations on heap tables can be performed online so they…

split_partition

Understanding DELETE vs TRUNCATE In Oracle Database

In Oracle, Segment Space Management is managing the space within a segment. In a segment generally you have USED block…

RETURNING INTO

Handling Duplicates in Collections In Oracle Database 19c

In our day to day life, sometimes we come across situations where we have to deal with duplicate values within…

RETURNING INTO

Understanding PRAGMA SERIALLY_REUSABLE In Oracle 19c

In Oracle, Package data consists of variables and constants that are defined at the package level—that is, not within a…