Shoumadip Das, Author at Shoumadip Das

Author: Shoumadip Das

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…

PRIVATE TEMPORARY TABLE Oracle 18c introduced the concept of a private temporary table, a memory-based temporary table that is dropped…

GLOBAL TEMPORARY TABLE Applications often use some form of temporary data store for processes that are too complicated to complete…

Oracle database allocates logical space for all data in the database. Logical storage structures are recognized by Oracle DB and…