Retrieve values in different format

[Geek_Guest]

Question asked by visitor Navi

Hi,
I want to achive the following in PL/SQL or by using any other method
Explanation

select col1,col2 from table;
Output will be
col1 col2
-------------
1 abc
2 xyz

but i want to get the display like below
col1 1 2
col2 abc xyz

How can i achive. Please ... thanks in advance

[debasisdas]

try to write matrix query using DECODE function.