Shoumadip Das - Page 2 of 5 - Oracle Data Architecture

One-stop resource for everything related to
Oracle Database

A package-based cache consists of one or more variables declared at the package level,rather than in any subprogram of the…

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

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…

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

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

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

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

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

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

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

A join method is the mechanism for joining two row sources. Depending on the statistics, the optimizer chooses the method…