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
4981 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 is the difference between a user and a schema in oracle?

What is a schema in oracle?

how to find count rows in table without count function?

3 Answers Oracle,

how many types of index?

2 Answers Cap Gemini, TCS,

Define 'view' advantage ?

2 Answers AZTEC, TCS,

How to rename an index?

What is a trigger and what are its types?

what is the syntax of UPDATE command?

Explain alias?

In Oracle 10g, "g" Stands for what?

5 Answers Mphasis,

What is the difference between sharding and partitioning?

what are different types of deletes?

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)