EXIT Statement in Oracle PLSQL

EXIT statement in Oracle PLSQL is most commonly used to end the LOOP statement’s execution. The Syntax for the EXIT Statement in Oracle PLSQL is: EXIT [WHEN boolean_condition]; Example of an EXIT Statement in Oracle PLSQL is: The above loop will execute the “sum := sum+1; statement 35 times. The loop will start counting from … Continue Reading

GOTO Statement in Oracle PLSQL

A GOTO Statement in Oracle PLSQL is used to redirect the code execution to a “Label” as specified in the GOTO statement. Syntax of the GOTO Statement in Oracle PLSQL is: GOTO label_name; Somewhere further in the code, we need to place the label “label_name” and provide the code to be executed. Example of GOTO … Continue Reading

CASE Statement in Oracle SQL PLSQL

A CASE Statement in Oracle SQL / PLSQL is having the functionality of IF-THEN-ELSE Statement. Syntax of the CASE Statement in Oracle SQL / PLSQL is: CASE [expression] WHEN condition_1 THEN result_1 WHEN consition_2 THEN result_2 WHEN condition_3 THEN result_3 . . WHEN condition_N THEN result_N ELSE default_result END; expression is an optional value, if … Continue Reading