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
Which is better Oracle or MS SQL? Why?
How to define a variable of a specific record type?
what are steps for interface? where is exchange rate defined in which table?
How a tablespace is related to data files?
How to fetch the row which has the max value for a column?
How to speed up webrick?
What is literal?
What are the oracle built-in data types?
How to compare dates in oracle sql?
How to connect the oracle server as sysdba?
material view and view disadvantages?
Explain enable novalidate constraint.
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
What are the four Oracle system processes that must always be up and running for the database to be useable?
What to do if the binary spfile is wrong for the default instance?