hi friends, I have a table A col as status|NUM and value as open |1 ope

Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Question Posted / srikant061

1 Answers
4897 Views
CTS, I also Faced
E-Mail Answers

hi friends, I have a table A col as status|NUM and value as open |1 open |2 close |3 clo..

Answer / 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

More Oracle General Interview Questions

what are the database links ?

How to get last row id?

diff between DELETE and TRUNCATE?.

14 Answers HCL, Yalamanchili Software,

Draw E-R diagram for many to many relationship ?

0 Answers Keane India Ltd,

How to retrieve the count of updated rows?

What is recovery manager(rman) backup in Oracle?

0 Answers MCN Solutions,

How are extents allocated to a segment?

What is dual table oracle?

What is the difference between a hot backup and a cold backup in oracle?

what is meant by magic query

Explain view?

what are steps for interface? where is exchange rate defined in which table?

For more Oracle General Interview Questions Click Here

Categories

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)
Oracle Security (38)
Oracle Forms Reports (510)
Oracle Data Integrator (ODI) (120)
Oracle ETL (15)
Oracle RAC (93)
Oracle D2K (72)
Oracle AllOther (241)