Hi Calvin,

I am working on oracle 8i,
Can we rephrase this so that it will work in 8i as well..

I was interested in it because it doesnot have any union or a sub query..This will positively reduce the execution time..

If you look into this it will be of a great help.

Thanks for you help Calvin.


Warm Regards,

Paddy