hi friends,
I have a table A
col as
status|NUM
and value as
open |1
open |2
close |3
close |3
the O/P should be
open|close
1 |3
2 |4
Answer Posted / ajit
select decode ( status, 'open', num ) open,
decode ( status, 'close', num ) close
from A;
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How to convert times to characters in oracle?
Explain the use of full option in exp command.
How do we create privileges in oracle?
What is a trigger and what are its types?
How to define an anonymous block?
How to create a new user account in oracle?
What are group functions in oracle?
What are named parameters?
What is oracle update statement with inner join ?
How to use like conditions in oracle?
What happens if you lost a data file?
What is a nvl function?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
What is truncate oracle?
What is a sub query? What are its various types?