- SQL
- January 30, 2025
Understanding SELECT FOR UPDATE In Oracle Database
The SELECT FOR UPDATE statement is a special variation of the normal SELECT statement, which proactively issues row locks on…

- PL/SQL
- July 10, 2022
WITH CLAUSE/SUBQUERY FACTORING OPTIMIZATION
If the content of the WITH clause is sufficiently complex, Oracle may decide to resolve the subquery into a global…

- SQL
- May 18, 2022
Understanding RealTime Materialized View In Oracle Database 19c
In earlier Oracle version, QUERY REWRITE feature used to stop working as soon as the materialized view become STALE, unless…

- Performance Tuning
- April 25, 2022
Understanding SET TRANSACTION In Oracle 19c
The SET TRANSACTION statement allows you to begin a read-only or read-write session,establish an isolation level,or assign the current transaction…

- Architecture
- March 28, 2022
Understanding DBMS_SHARED_POOL Package
The DBMS_SHARED_POOL package provides access to the shared pool, which is the shared memory area where cursors and PL/SQL objects…

- PL/SQL
- February 20, 2022
Understanding SET Operations In NESTED TABLE
Out of the three collection types, NESTED TABLE collection type supports SET operations in Oracle. x MULTISET EXCEPT [DISTINCT] y…

- PL/SQL
- December 19, 2021
Understanding Oracle 12c ACCESSIBLE BY CLAUSE
The ACCESSIBLE BY clause can be added to packages, procedures, functions and types to specify which objects are able to…

- PL/SQL
- October 17, 2021
Understanding DBMS_OUTPUT Package
Oracle provides the DBMS_OUTPUT package to enable you to send information from your programs to a buffer. This buffer can…

- PL/SQL
- August 29, 2021
Understanding Private Temporary Table In Oracle
PRIVATE TEMPORARY TABLE Oracle 18c introduced the concept of a private temporary table, a memory-based temporary table that is dropped…

- PL/SQL
- August 29, 2021
Understanding Global Temporary Table In Oracle
GLOBAL TEMPORARY TABLE Applications often use some form of temporary data store for processes that are too complicated to complete…

- Architecture
- July 25, 2021
Row Migration Vs Row Chaining
Oracle database allocates logical space for all data in the database. Logical storage structures are recognized by Oracle DB and…