8. SQL Statements : DECLARE : Syntax
 
Share this page                  
Syntax
The DECLARE statement has the following format:
DECLARE var_name {, var_name} [=] var_type
              [NOT NULL [WITH | NOT DEFAULT] | WITH NULL];
              {var_name {, var_name} [=] var_type
              [NOT NULL [WITH | NOT DEFAULT] | WITH NULL];}
var_name
Specifies the name of the local variable. A variable name must be unique within the procedure; it cannot match the name of any other procedure variable or parameter.
var_type
Is the data type of the variable. A local variable can be any data type except a SYSTEM_MAINTAINED TABLE_KEY or OBJECT_KEY.