user12391095
user12391095

Reputation:

can case statement be used in calling procedure at runtime

Is this possible :-

EXEC PROC1 (case when 1=2 then A else B).

Upvotes: 0

Views: 62

Answers (1)

Tony Andrews
Tony Andrews

Reputation: 132670

Yes:

SQL> set serveroutput on
SQL> exec dbms_output.put_line (case when 1=2 then 'A' else 'B' end);
B

PL/SQL procedure successfully completed.

Upvotes: 1

Related Questions