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.