Learning is not a spectator sport
Connor McDonald on SQL and the Oracle Database
Tag: 19c
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 along…nothing else to see here Sometimes you can’t make use of a facility that you normally would, and you have to substitute in something…
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; DEPTNO ENAME ———- ———- 10 CLARK 10 KING 10 MILLER 20 ADAMS 20 FORD 20 JONES 20 SCOTT 20 SMITH 30 ALLEN 30 BLAKE…
