Re: "un-grouping" results

Just discovered today. How many rows

select dummy, prior dummy
from dual
connect by dummy > prior dummy
and prior dummy is not null
and prior dummy is null
and prior dummy = 'a'
and prior dummy <> 'a'

is expected to return? Received on Mon Feb 07 2005 - 16:14:18 CST