Category: PL/SQL

compound trigger

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…

PRAGMA EXCEPTION_INIT

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…