Hi All,
I have a table/sql like this...
==================================================================
SELECT 1001 ID,'Duplicate' name,'Yes' status,'test date' com from dual
union
SELECT 1001 ID,'check' name,'No' status,'test date' com from dual
union
SELECT 1001 ID,'reflected' name,'Yes' status,'ok' com from dual
union
SELECT 1002 ID,'merged' name,'Yes' status,'test date' com from dual
union
SELECT 1002 ID,'executed' name,'No' status,'test date....' com from dual
================================================================
Final output all columns vlaues into single row
| ID | NAME VALUES | STATUS | COM | NAME VALUES | STATUS | COM | NAME VALUES | STATUS | COM |
| 1001 | Duplicate | Yes | test date | check | No | test date | reflected | Yes | ok |
| 1002 | executed | No | test date | merged | Yes | test date |
Please hlep me on this....