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