-
Retrieve values in different format
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
-
Re: Retrieve values in different format
try to write matrix query using DECODE function.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules