Shoumadip Das - Oracle Data Architecture

One-stop resource for everything related to
Oracle Database

Oracle SQL hints are used to manually control the execution plan of a query, overriding the optimizer’s default decisions regarding…

Oracle SQL hints are used to manually control the execution plan of a query, overriding the optimizer’s default decisions regarding…

One particularly interesting type of package data is the explicit cursor.I can declare a cursor in a package, in either…

If you plan on updating or deleting records that have been referenced by a SELECT FOR UPDATE statement, you can…

EXCEPTION_INIT is a compile-time command or pragma used to associate a exception name with an internal error code.EXCEPTION_INIT instructs the…

As of Oracle 12.1, you can now define invisible columns in relational tables. An invisible column is a user-defined hidden…

Oracle allows more than one trigger to be created for the same timing point, but it has never guaranteed the…

XMLType is used to store and manipulate XML data. You can use XMLType to define database columns and PL/SQL variables…

• Simple CASE statement evaluates a expression and executes the statement or sequence of statements associated with the first condition…

In real world, as you create more and more triggers containing more and more business logic, it becomes difficult to…

The RETURNING INTO clause specifies the variables in which to store the values returned by the statement to which the…