Variables and Types : Variable « PL SQL Programming « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. PL SQL Programming
  3. Variable

Variables declared within the DECLARE section of a PL/SQL block may only be referenced within that block.

A variable declaration has both a name and a type.

For example, the width variable was declared as:

width INTEGER;
24.2.Variable
24.2.1.Variables and Types
24.2.2.A variable is null if a value hasn't been assigned to it yet
24.2.3.In SQL statements, the names of database columns take precedence over the names of local variables and formal parameters