... until the collector arrives ...

This "blog" is really just a scratchpad of mine. There is not much of general interest here. Most of the content is scribbled down "live" as I discover things I want to remember. I rarely go back to correct mistakes in older entries. You have been warned :)


Oracle 9i

Under Oracle, the following statement fails with the nonsensical error 'ORA-00979: not a GROUP BY expression':

select (select max(dummy) from dual where dummy=a.dummy)
from dual a
, ( select dummy from dual group by dummy ) b
where a.dummy = b.dummy
and a.dummy = 'X'

Under Oracle, the statement works.

Blog Archive