The missing multiplication aggregation in SQL
A few days back on Twitter, a cool little discussion arose out of the SQL Daily regular tip – the
Tag: listagg
Code re-use in PL/SQL might just need SQL
I was doing some code review today of a PL/SQL package, and came across a routine to generate a list
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 