PL/SQL Archives - Shoumadip Das

Category: PL/SQL

A package-based cache consists of one or more variables declared at the package level,rather than in any subprogram of the…

INSTEAD OF triggers are essentially alternatives to DML triggers. They fire when inserts, updates, and deletes are about to occur;…

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…

TABLE FUNCTION A table function is a function that can be called from within the FROM clause of a query,as…

In our day to day life, sometimes we come across situations where we have to deal with duplicate values within…

In Oracle, Package data consists of variables and constants that are defined at the package level—that is, not within a…

In Oracle, the DBMS_XMLGEN package converts the results of a SQL query to a canonical XML format. The package takes…

AUTHID CURRENT_USER It is used when we want a routine to be executed with the privileges of the invoker and…

The default behavior of AUTONOMOUS TRANSACTIONS is that once a COMMIT/ROLLBACK occurs in the AUTONOMOUS TRANSACTION, those changes are visible…

If the content of the WITH clause is sufficiently complex, Oracle may decide to resolve the subquery into a global…