Category: PL/SQL
![join_methods](https://www.oraclemasterpiece.com/wp-content/uploads/2021/08/gtt-1-372x240.jpg)
- PL/SQL
- February 20, 2022
Understanding SET Operations In NESTED TABLE
Out of the three collection types, NESTED TABLE collection type supports SET operations in Oracle. x MULTISET EXCEPT [DISTINCT] y…
![Accessible By](https://www.oraclemasterpiece.com/wp-content/uploads/2021/12/775-372x240.jpeg)
- PL/SQL
- December 19, 2021
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…
![pkg_caching](https://www.oraclemasterpiece.com/wp-content/uploads/2021/02/final-372x240.jpg)
- PL/SQL
- October 17, 2021
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](https://www.oraclemasterpiece.com/wp-content/uploads/2021/08/ptt-372x240.jpg)
- 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…
![join_methods](https://www.oraclemasterpiece.com/wp-content/uploads/2021/08/gtt-1-372x240.jpg)
- 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…
![pkg_caching](https://www.oraclemasterpiece.com/wp-content/uploads/2021/02/final-372x240.jpg)
- 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…
![Oracle-collection-method](https://www.oraclemasterpiece.com/wp-content/uploads/2020/11/Oracle-Collection-methods-372x240.jpg)
- 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…