Home » SQL & PL/SQL » SQL & PL/SQL » HOW CAN I DO THIS QUERY
HOW CAN I DO THIS QUERY [message #325729] Sun, 08 June 2008 03:55 Go to next message
LAZYGIRL
Messages: 34
Registered: May 2006
Member
I HAVE QUERY THAT DISPLAY THE RESULT LIKE THIS

1 select UNIQUE DECODE (T.PBLCDE,'001','UOB','EXT') PBL
2* from BOOKS t
SQL> /

PBL
---
EXT
UOB

BUT I WANT TO DISPLAY THE RESULT LIKE THIS

UOB EXT

I HAVE SEEN THE ANSWER SOME WHERE BUT I DON'T REMEMBER

CAN ANY ONE HELP PLEASE
Re: HOW CAN I DO THIS QUERY [message #325735 is a reply to message #325729] Sun, 08 June 2008 04:15 Go to previous message
flyboy
Messages: 1832
Registered: November 2006
Senior Member
From wikipedia:
Quote:
Common rules for e-mail[9] and USENET such as avoiding flamewars and spam are constant across most mediums and communities. Another rule is to avoid typing in ALL CAPS, which is considered shouting or yelling.

Please, stop with it immediately.

To your question: although the query does not make logical sense to me, the requirement is a classical pivot operation.
Previous Topic: urgent: changing non-empty column type?
Next Topic: problem avoiding Mutating trigger
Goto Forum:
  


Current Time: Thu Dec 08 12:35:15 CST 2016

Total time taken to generate the page: 0.06650 seconds