Author: Shoumadip Das
- SQL
- February 23, 2024
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….
- Architecture
- December 18, 2023
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….
- PL/SQL
- July 17, 2023
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…
- Architecture
- January 22, 2023
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…
- 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…