Category: PL/SQL
- PL/SQL
- March 6, 2025
Understanding RETURNING INTO Clause In Oracle Database.
The RETURNING INTO clause specifies the variables in which to store the values returned by the statement to which the…
- PL/SQL
- March 6, 2025
Understanding OPEN FOR Statement In Oracle Database.
OPEN FOR statement is used to support multiple-row dynamic queries. OPEN cursor_variable|host_cursor_variable} FOR sql_string USING bind_argument; The bind_argument is always…
- PL/SQL
- May 26, 2024
Understanding Package Level Caching In Oracle Database.
A package-based cache consists of one or more variables declared at the package level,rather than in any subprogram of the…
- PL/SQL
- April 3, 2024
Understanding Oracle INSTEAD OF TRIGGER
INSTEAD OF triggers are essentially alternatives to DML triggers. They fire when inserts, updates, and deletes are about to occur;…
- PL/SQL
- July 17, 2023
Log Sub-Program Parameter Values Using LOG4PL/SQL Framework In Oracle Database 19c
LOG4PLSQL is an open source tool that uses PL/SQL framework to log into PL/SQL code package,function,web application,procedure, trigger and various…
- PL/SQL
- January 2, 2023
Understanding Difference Between Table Function & PIPELINED Table Function In Oracle Database 19c
TABLE FUNCTION A table function is a function that can be called from within the FROM clause of a query,as…
- 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…