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
5043 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

Which Oracle App Is Most Popular One ?

What is Undo Management Advisor in Oracle?

0 Answers MCN Solutions,

How many categories of data types?

What do you mean by merge in oracle and how can we merge two tables?

What are internal user account in oracle?

What is the difference between translate and replace in oracle?

What is a table index?

what are the diffeenes between oracle 9i,oracle 10g

How do I start tns listener?

What is the difference between SQL, DDL, and DML?

7 Answers BeBo Technologies, Wipro,

What is format trigger?

What do you mean by merge in oracle and how can you merge two tables?

For more Oracle General Interview Questions Click Here

Categories

Oracle General (1803)
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)