Category: PL/SQL
- PL/SQL
- November 20, 2022
Handling Duplicates in Collections In Oracle Database 19c
In our day to day life, sometimes we come across situations where we have to deal with duplicate values within…
- PL/SQL
- November 8, 2022
Understanding PRAGMA SERIALLY_REUSABLE In Oracle 19c
In Oracle, Package data consists of variables and constants that are defined at the package level—that is, not within a…
- PL/SQL
- October 28, 2022
Understanding DBMS_XMLGEN Package In Oracle 19c
In Oracle, the DBMS_XMLGEN package converts the results of a SQL query to a canonical XML format. The package takes…
- PL/SQL
- September 30, 2022
Understanding AUTHID Clause In Oracle
AUTHID CURRENT_USER It is used when we want a routine to be executed with the privileges of the invoker and…
- PL/SQL
- August 22, 2022
Understanding AUTONOMOUS TRANSACTION with ISOLATION LEVEL
The default behavior of AUTONOMOUS TRANSACTIONS is that once a COMMIT/ROLLBACK occurs in the AUTONOMOUS TRANSACTION, those changes are visible…
- PL/SQL
- July 10, 2022
WITH CLAUSE/SUBQUERY FACTORING OPTIMIZATION
If the content of the WITH clause is sufficiently complex, Oracle may decide to resolve the subquery into a global…
- 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…
- 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…
- 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…
- 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…