SQLcl – SQL*Plus with Benefits
Do you like working from the command line in sqlplus? Then you will love doing so in SQLcl. You don’t like working from the command... Read More
Partitioning 101
Data is getting bigger at an ever increasing rate. Does this mean it is time to ditch your relational database and look at BigData alternatives?... Read More
A Faster Way to Do COUNT ( DISTINCT )
Oracle 19c introduced an unusual set of new SQL functions: Aggregation functions to create a bitmap: BITMAP_CONSTRUCT_AGG,ֲ BITMAP_OR_AGG Relational operators: BITMAP_COUNT,ֲ BITMAP_BIT_POSITION,ֲ BITMAP_BUCKET_NUMBER What they do and how... Read More
Five Things You Might Not Have Known about the Oracle Database
In this session, we’ll look at 5 things you might not have known about the Oracle Database – or that you might have known about... Read More
Zero-Downtime Application Upgrades Made Easy
Do you shut your Oracle-based system down for application upgrades? Do you upgrade only at nights and weekends (when you are tired and angry) for... Read More
One Less Thing to Worry About: Automatic Index Creation (AIC)
You’re a busy Oracle DBA. Your phone rings. It’s your most troublesome user, once again complaining that her query is running slow. You take a... Read More
A Gentle Introduction to Polymorphic Table Functions
Oracle database 18c introduces Polymorphic Table Functions. This session will tell you about Polymorphism. How can you apply this in pre-18c databases? I will show... Read More
Keynote:
Oracle APEX – The Quiet Revolution in Application Development
Oracle APEX, the low code application framework included with Oracle Database, has quietly grown into a mature, modern and robust application development and deployment platform... Read More