Hi Sanjay,

This script works for normal tables with datatype as NUMBER,VARCHAR2,DATE etc.

But, i use XMLTYPE , internally Oracle will store it as LOB.

So, when i query the records i get the following errors:

ERROR at line 1:
ORA-22950: cannot ORDER objects without MAP or ORDER method

I used the similar one manually, by using UNION, it fails because of XMLTYPE.

More over, i need to select the rows table by table not by using UNION.


Thanks
gandhi
OCP-DBA.