Author: Shoumadip Das

- PL/SQL
- January 2, 2023
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…

- Performance Tuning
- December 5, 2022
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…

- Architecture
- November 28, 2022
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…

- PL/SQL
- November 20, 2022
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…

- PL/SQL
- November 8, 2022
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…

- PL/SQL
- October 28, 2022
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…

- SQL
- October 17, 2022
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…

- PL/SQL
- September 30, 2022
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…

- SQL
- September 18, 2022
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…

- PL/SQL
- August 22, 2022
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…