Shoumadip Das - Page 4 of 6 - Oracle Data Architecture

One-stop resource for everything related to
Oracle Database

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

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

A join method is the mechanism for joining two row sources. Depending on the statistics, the optimizer chooses the method…

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…