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

Question Posted / srikant061

1 Answers
4178 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

how can db_files > maxdatafiles since db_files is for instance and the later is for database

0 Answers CTS,

What is backup in Oracle?

0 Answers MCN Solutions,

What is Java Pool in Oracle?

0 Answers MCN Solutions,

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

0 Answers

Explain the use of parfile option in exp command.

0 Answers

How to view existing locks on the database?

0 Answers

How to store only time; not date and time?

0 Answers

i want department wise maxmum salary and empolyee name

9 Answers

How to estimate disk space needed for an export job?

0 Answers

what is the syntax of INSERT command?