Category: PL/SQL
- 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…
- 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…
- 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…