Category: PL/SQL

ptt

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…

join_methods

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…

duplicate_in_collection

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…

Oracle-collection-method

PL/SQL Collection Methods

WHAT IS COLLECTION ? A collection is a data structure that acts like a list or a single-dimensional array of…