Unfortunately, Oracle does not support this feature. I sure wish it did.

There are workarounds, typically involving writing a recursive procedure to do the job, but then you end up having to do multiple SELECTs when it would be nice to do just one.

Mitchell