I have a scenario wherein I have to write multiple conditional statements -
SET SERVEROUTPUT ON
DECLARE
v_test VARCHAR2(100) := 'ABCDEF';
BEGIN
IF INSTR(v_test,'A')> 0
THEN
DBMS_OUTPUT.PUT_LINE('A');
END IF;
IF INSTR(v_test,'B')> 0
THEN
DBMS_OUTPUT.PUT_LINE('B');
END IF;
IF INSTR(v_test,'C')> 0
THEN
DBMS_OUTPUT.PUT_LINE('C');
END IF;
END;
/
Is there a more elegant way of writing this, instead of multiple IF - END IF statemnets?
Say something like
<<Conditional Operator>> INSTR(v_test,'A')> 0 THEN DBMS_OUTPUT.PUT_LINE('A');
<<Conditional Operator>> INSTR(v_test,'B')> 0 THEN DBMS_OUTPUT.PUT_LINE('B');
<<Conditional Operator>> INSTR(v_test,'C')> 0 THEN DBMS_OUTPUT.PUT_LINE('C');