declaring variables in pl sql 1

declaring variables in pl sql

# variableName variableType := Value;
# EG :
DECLARE
	name varchar(15) := 'Name';
BEGIN
	DBMS_OUTPUT.PUT_LINE(name)
END;

Here is what the above code is Doing:
1. Declare a variable called name of type varchar(15) and assign it the value ‘Name’.
2. Print the value of the variable name.

Similar Posts