10. PL/SQL GO TO & NULL Statement | PL/SQL Developer Course | TechView Team | Hindi
#techviewteam #plsql
In this video we discuss about oracle Conditional Control [ IF/ELSE & CASE] Statement with practical example.
This is 10th video from series of videos about PL/SQL. so, you are requested to watch complete playlist for better understanding.
-------------------Video Notes start from here----------------------------
------------GO TO statement
GOTO label_name;
In the program, you surround the label name with double enclosing angle brackets as shown below:
--label_name--;
------GOTO sample----------
BEGIN
GOTO second_message;
-first_message-
DBMS_OUTPUT.PUT_LINE( 'Hello' );
GOTO the_end;
-second_message-
DBMS_OUTPUT.PUT_LINE( 'Programme Start from second label' );
GOTO first_message;
-the_end-
DBMS_OUTPUT.PUT_LINE( 'and good bye...' );
END;
--------------
----NUL ----
DECLARE
b_status BOOLEAN
BEGIN
IF b_status THEN
GOTO end_of_program;
END IF;
------ further processing here
------ ...
-end_of_program-
NULL;
END;
---------------
Note that an error will occur
if you don’t have the NULL statement after the end_of_program label.
----------
CREATE PROCEDURE request_for_aproval(
customer_id NUMBER
)
AS
BEGIN
NULL;
END;
-----------
-----------------
Note :- greater than symbol not allowed in this description section so please replace -- with greater than or less than symbol.
Regards
TechView Team