Category Archives: Syntax

Extremely useful Partitioning enhancements in Oracle Database 12c

Back in January, I promised I would write a series of blogs on some of my favorite new 12c enhancements, designed to make your life easier. I’m finally getting around to keeping that promise with this weeks blog post on my … Continue reading

Posted in Oracle Database 12c New Features, Partititoning, Syntax | Tagged , | 1 Comment

Optimizer Histograms

At the recent OUG Ireland conference I had the privilege of participating in a panel discussion on the Oracle Database. During the course of the session the topic of Optimizer histograms came up. As always, a heated discussion ensued among … Continue reading

Posted in Optimizer, Statistics, Syntax | Tagged , , | 6 Comments

New Top-N Queries and Pagination Syntax

At the RMOUG Training Days, a couple of weeks, ago @GeraldVenzl and I delivered a session demonstrating what it would take to get a REST enabled, web-based application up and running with Oracle Database 12c. During the session Gerald asked me … Continue reading

Posted in Oracle Database 12c New Features, Syntax | Tagged , | 1 Comment