Category: PL/SQL

- PL/SQL
- August 29, 2021
Understanding Private Temporary Table In Oracle
PRIVATE TEMPORARY TABLE Oracle 18c introduced the concept of a private temporary table, a memory-based temporary table that is dropped…

- PL/SQL
- August 29, 2021
Understanding Global Temporary Table In Oracle
GLOBAL TEMPORARY TABLE Applications often use some form of temporary data store for processes that are too complicated to complete…

- PL/SQL
- February 21, 2021
Collection As Table Column Datatype
In PL/SQL,we can use both VARRAY & NESTED TABLE collection type as table column datatype. The difference between these implementation…

- PL/SQL
- November 23, 2020
PL/SQL Collection Methods
WHAT IS COLLECTION ? A collection is a data structure that acts like a list or a single-dimensional array of…