Shoumadip Das - Oracle Data Architecture

One-stop resource for everything related to
Oracle Database

A Top-N query is used to retrieve the top or bottom N rows from an ordered set. Combining two Top-N…

A Top-N query is used to retrieve the top or bottom N rows from an ordered set. Combining two Top-N…

INSERT APPEND BEGINDATA You can also specify the data directly inside the control file itself using BEGINDATA keyword. i.e Anything…

SQL*Loader allows you to load data from an external file into a table in the database. It can parse many…

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…