Author: Shoumadip Das

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…

for_update

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…

for_update

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…

for_update

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…

join_methods

Understanding Join Methods In Oracle Database 19c

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

for_update

Understanding AUTHID Clause In Oracle

AUTHID CURRENT_USER It is used when we want a routine to be executed with the privileges of the invoker and…

deterministic_result_cache

Understanding Clustering In Oracle Database

Clustering is a method of storing tables that are intimately related and often joined together into the same area on…

autonomous_transaction_isolation

Understanding AUTONOMOUS TRANSACTION with ISOLATION LEVEL

The default behavior of AUTONOMOUS TRANSACTIONS is that once a COMMIT/ROLLBACK occurs in the AUTONOMOUS TRANSACTION, those changes are visible…