- SQL
- April 14, 2024
Understanding Materialized View ON PREBUILT TABLE
The “ON PREBUILT TABLE” clause is used when you have already created a replicated table using “CTAS” and now want…
- SQL
- April 14, 2024
Understanding Materialized View ON PREBUILT TABLE
The “ON PREBUILT TABLE” clause is used when you have already created a replicated table using “CTAS” and now want…
- SQL
- April 14, 2024
Understanding DML Statements on a SQL Join View
A join view is a view based on a join. Special considerations apply when you issue a DML(INSERT, UPDATE, or…
- SQL
- April 3, 2024
Understanding Oracle SYS_CONTEXT
The SYS_CONTEXT function is used in both SQL & PL/SQL to return information about the Oracle environment that you’re working…
- PL/SQL
- April 3, 2024
Understanding Oracle INSTEAD OF TRIGGER
INSTEAD OF triggers are essentially alternatives to DML triggers. They fire when inserts, updates, and deletes are about to occur;…
- SQL
- February 23, 2024
Understanding Oracle External Tables
External tables are read-only tables that allow Oracle to query data that is stored outside the database in flat files….
- Architecture
- December 18, 2023
Understanding ROWID In Oracle Database
Every record has a unique ROWID (pseudocolumn) within a database representing the physical location on disk where the record lives….
- PL/SQL
- July 17, 2023
Log Sub-Program Parameter Values Using LOG4PL/SQL Framework In Oracle Database 19c
LOG4PLSQL is an open source tool that uses PL/SQL framework to log into PL/SQL code package,function,web application,procedure, trigger and various…
- Architecture
- January 22, 2023
Understanding Index Compression In Oracle Database 19c
From Oracle 9i onward both non-unique and unique indexes can be compressed to save disk space. The COMPRESS [N] clause…
- PL/SQL
- January 2, 2023
Understanding Difference Between Table Function & PIPELINED Table Function In Oracle Database 19c
TABLE FUNCTION A table function is a function that can be called from within the FROM clause of a query,as…
- Performance Tuning
- December 5, 2022
Understanding ONLINE Split Partition In Oracle Database 12c.
In Oracle Database 12c Release 2 (12.2) the SPLIT PARTITION operations on heap tables can be performed online so they…