Category: PL/SQL
- PL/SQL
- December 25, 2025
Understanding PRAGMA EXCEPTION_INIT In Oracle Database
EXCEPTION_INIT is a compile-time command or pragma used to associate a exception name with an internal error code.EXCEPTION_INIT instructs the…
- PL/SQL
- December 25, 2025
Understanding FOLLOWS Clause In Oracle Database
Oracle allows more than one trigger to be created for the same timing point, but it has never guaranteed the…
- PL/SQL
- April 5, 2025
Understanding XMLType In Oracle Database.
XMLType is used to store and manipulate XML data. You can use XMLType to define database columns and PL/SQL variables…
- PL/SQL
- April 5, 2025
Understanding Compound Trigger In Oracle Database.
In real world, as you create more and more triggers containing more and more business logic, it becomes difficult to…
- 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…