

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...
7 days ago3 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


Advanced Index Compression in the Oracle Database
This blog is part of the overall " 10 Oracle Database Features That Fly Under the Radar " and explains what Advanced Index Compression is...
Jan 214 min read