Take care with Read-Only partitions in 18c
The ability for part of a table to be read-only and other parts of the same table to allow full
Search Results for: 19c
Upgrading from 19.6 to 19.7 on Windows
I must say this Release Update (RU) was probably the smoothest I’ve ever done. Obviously you should always read the
Why you might add columns to external tables
Let me start with the idiotic part first. That part would be…. me! I’ll create an external table which reads
Tightened security in 20c for Oracle maintained accounts
If you cannot wait for a fully autonomous offering, and you’ve jumped into the 20c preview release on Oracle Cloud,
DBMS_JOB – the joy of transactions
This is a followup to yesterdays post on DBMS_JOB and is critical if you’re upgrading to 19c soon. Mike Dietrich
Use the features available!
Advance warning: This post is a just another normal Friday morning rant. If you’re not interested in my pontificating, move
LISTAGG hits prime time
It’s a simple requirement. We want to transform this: SQL> select deptno, ename 2 from emp 3 order by 1,2;
Learning is not a spectator sport 