Oracle PL/SQL - Restrictions on the declaration of variables

Introduction

There are some restrictions on the declaration of variables:

There is no forward declaration.

Multiple declarations supported in some languages are not allowed in PL/SQL, as shown here:

declare 
      v1_nr, v2_nr NUMBER; -- INVALID 
      -- VALID 
      v1_nr NUMBER; 
      v2_nr NUMBER; 
begin 
      ...     

Related Topic

• Variable Declarations
• Variable Initialized to NULL by Default
• Variable NOT NULL Constraint
• Variables Initialized to NULL Values
• Declaring Variable of Same Type as Another Variable
• Assigning Values to Variables with the Assignment Statement
• Assigning Values to Variables with the SELECT INTO Statement
• Assigning Values to Variables as Parameters of a Subprogram
• Assigning Values to BOOLEAN Variables
• Declaring variables
• Assigning values to variables
• Assign SQL query results to PL/SQL variables

• Previous
• Next