Category: PL/SQL

Accessible By

Understanding Oracle 12c ACCESSIBLE BY CLAUSE

The ACCESSIBLE BY clause can be added to packages, procedures, functions and types to specify which objects are able to…

fncbased_indx

Understanding DBMS_OUTPUT Package

Oracle provides the DBMS_OUTPUT package to enable you to send information from your programs to a buffer. This buffer can…

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…

fncbased_indx

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…