One-stop resource for everything related to
Oracle Database

external_tables

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….

external_tables

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….

external_tables

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….

external_tables

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…

external_tables

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…

external_tables

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…

external_tables

Understanding DBMS_XMLGEN Package In Oracle 19c

In Oracle, the DBMS_XMLGEN package converts the results of a SQL query to a canonical XML format. The package takes…