Shoumadip Das - Oracle Data Architecture

One-stop resource for everything related to
Oracle Database

The Oracle PARALLEL hint instructs the optimizer to use a specified number of concurrent servers (degree of parallelism, or DOP)…

The Oracle PARALLEL hint instructs the optimizer to use a specified number of concurrent servers (degree of parallelism, or DOP)…

Oracle employs several methods, known as access paths, to retrieve data for a SQL statement. Optimizer hints are comments within…

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…