Oracle PL/SQL: Declaring Variables - Variables are very useful in PL/SQL, indeed in all programming languages. They allow you to set a va

Quick Search:

Oracle PL/SQL: Declaring Variables

Jump to:

Category: >> Oracle PL/SQL >> Declaring Variables

<< last

next >>

Snippet Name: 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.

Also see:
» SEQUENCE: get sequence value into vari...
» Anonymous blocks: Constants and Variab...

Comment: (none)

Language:
Highlight Mode: PLSQL
Last Modified: March 07th, 2009

The syntax FOR declaring variables IS:
 
variable_name [CONSTANT] datatype [NOT NULL] [:= | DEFAULT initial_value]
 
 
 
FOR example:
 
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';