Declaring Variables

Description: Variables are very useful in PL/SQL, indeed in all programming languages. They allow you to set a values once and use it many times throughout the code.

The syntax FOR declaring variables IS:
variable_name [CONSTANT] datatype [NOT NULL] [:= | DEFAULT initial_value]
FOR w3mentor:
Declaring a variable:
LDescription VARCHAR2(40);
Declaring a CONSTANT:
LTotal CONSTANT numeric(8,1) := 8363934.1;
Declaring a variable WITH an initial VALUE (NOT a CONSTANT):
LType VARCHAR2(10) := 'Example';

Enjoyed this post? Share it!


Leave a comment

Your email address will not be published.