Creating a program in PL/SQL :
You can create a program after understanding the syntax and usage of PL/SQL . I am going to create a program which will show the value of variable :
Code:
DECLARE
var NUMBER;
BEGIN
var := 72600;
dbms_output.put_line('The variable var = ');
dbms_output.put_line(var);
END;
.The variable is declared in the DECLARE section and central logic of program is reside under the BEGIN and END.The value is assigned to the var variable with the help of ":="operator which is unique with all programming languages.
Bookmarks