

Read-Only Partitions and Subpartitions in the Oracle Database
Today's throwback feature of the week is Read-Only Partitions and Subpartitions. Read-only partitions let you block the inserts, updates,...
Jun 262 min read


Real Time Materialized Views
Today's throwback feature of the week is the Real-Time Materialized View. What are Materialized Views and how are they different from...
May 294 min read


Global Temporary Tables in the Oracle Database
Today's throwback feature of the week is the Global Temporary Table (GTT). Global Temporary Tables are permanent database objects stored...
May 83 min read


Virtual Columns in the Oracle Database
This week's throwback feature of the week is the virtual column. Virtual Columns let you create columns that aren't stored physically but...
Apr 242 min read


PIVOT and UNPIVOT in the Oracle Database
This week's throwback feature of the week is a simple and relatively well known SQL Operator. It's the ability to pivot and unpivot SQL...
Apr 173 min read


Identity Columns in the Oracle Database
This week's throwback feature of the week is the Identity Column. Identity Columns give you an easy way to create unique numeric...
Apr 103 min read


PL/SQL Function Results Cache - A Smart Memory for Your Database
This week's throwback feature of the week is the PL/SQL Function Results Cache. This feature lets you easily cache commonly calculated...
Apr 33 min read