A simple program in PL/SQL
Above program executed and printed the output as “PL/SQL procedure successfully completed.” but not printed “Hello Learner”.
We need to execute “SET SERVEROUTPUT ON” if we need to see the output of the code.
Declaring and usage of variables in program
Here, DECLARE statement is used to declare the variables and := operation is used to assign value to the variable.
DBMS_OUTPUT.PUT_LINE is used to print the values.
Comments let you include text within your code to explain what the code does. PL/SQL compiler ignores comments.
PL/SQL supports two types of comments.
- Single line comments (- -)
- Multi line comments (/* ……….*/)