The user issues the following statement. What will be displayed if the EMPID selected is 60494? SELECT DECODE(empid, 38475, "Terminated",60494, "Recruited", "NotRecruited") FROM emp;A. 60494B. 38475C. TerminatedD. Recruited

  • Interview Candidate
  • 2
  • 2446

Showing Answers 1 - 2 of 2 Answers

Partha

  • Jun 30th, 2006
 

the decode command works similar to switch case and here the input is 60494 which matches to "Recruited" thus output is Recruited

 SELECT DECODE(empid, 38475, "Terminated",60494, "Recruited", "Not
Recruited") FROM emp;

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions