Shoumadip Das - Page 3 of 5 - Oracle Data Architecture

One-stop resource for everything related to
Oracle Database

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

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

Clustering is a method of storing tables that are intimately related and often joined together into the same area on…

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…

In earlier Oracle version, QUERY REWRITE feature used to stop working as soon as the materialized view become STALE, unless…

The SET TRANSACTION statement allows you to begin a read-only or read-write session,establish an isolation level,or assign the current transaction…

The DBMS_SHARED_POOL package provides access to the shared pool, which is the shared memory area where cursors and PL/SQL objects…

Out of the three collection types, NESTED TABLE collection type supports SET operations in Oracle. x MULTISET EXCEPT [DISTINCT] y…

The ACCESSIBLE BY clause can be added to packages, procedures, functions and types to specify which objects are able to…

Oracle provides the DBMS_OUTPUT package to enable you to send information from your programs to a buffer. This buffer can…