Just one point: i think that the creating objects as advised by Raj is heavier for performance. Try to test it, may be i wrong On Fri, Dec 28, 2012 at 12:20 AM, Andrew Kerber <andrew.kerber@xxxxxxxxx> wrote: > Hi, I already have the solution to this, thanks. Thanks to Raj Jamadagni > for providing the answerI had to change the query to read like this: > > > -- > Andrew W. Kerber > > 'If at first you dont succeed, dont take up skydiving.' -- Best regards, Sayan Malakshinov Senior performance tuning engineer PSBank Tel: +7 903 207-1576 -- //www.freelists.org/webpage/oracle-l