Q
Which Oracle function works like IF-THEN-ELSE by comparing an expression with search values?
-
A
CASE_WHEN_ONLY
-
B
SWITCH
-
C
DECODE
-
D
IFELSE
Correct Answer:
C. DECODE
Explanation:
DECODE(dept_id, 10, 'HR', 20, 'IT', 'Other') is Oracle-specific; CASE is the ANSI standard alternative.
