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
Fast Counting in the Oracle Database with APPROX_COUNT_DISTINCT
This blog is part of the overall " 10 Oracle Database Features That Fly Under the Radar " and explains what the APPROX_COUNT_DISTINCT...
Jan 222 min read
