No more stale statistics in 19c
There is an odd contradiction that we all encounter for most databases, especially if they are predominantly used during the
Tag: 19c
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
DBMS_JOB – watching for failures
I had a friend point this one out to me recently. They use DBMS_JOB to allow some “fire and forget”
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;
