Quick Search:
 Oracle PL/SQL: Declaring Variables Jump to:  
Category: >> Oracle PL/SQL >> Declaring Variables  

<< lastnext >>

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)

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';

   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org