DECLARE variable statement
Wed, 03/04/2009 - 20:02 | 
hdanzl
Declare one or more SQL variables.
Syntax
|
DECLARE <SQL variable name list> <data type> [ <default clause> ] |
Usage
The DECLARE statement is used to declare SQL variables. SQL variables that are declared in the context of triggers, procedures and functions are local to the statement block where they are declared. SQL variables that are declared in the context of the main executing statement block are global session variables.
Notes
| ♦ | SQL variable names shall conform to the rules for identifiers in NexusDB SQL. |
| ♦ | One ore more SQL variables can be declared with the same data type. |
| ♦ | The DEFAULT clause is used to specify an initial value for the variable, and is similar to setting a default value for a column. |
Examples
| 1) | The following examples declares two SQL variables with the same data type: |
DECLARE min, max INTEGER;
| 2) | The following example declares two SQL variables with different data types: |
DECLARE count INTEGER DEFAULT 0;
DECLARE total DOUBLE PRECISION DEFAULT 0;
Conformance
|
SQL:2003 standard |
- |
SQL/PSM Feature P002-04 "SQL variable declaration" |
Tags:
Questions? Problems?
- Interested to buy but something put you off?
- Can't find what you're looking for?
- Have a suggestion?
Let us know. If you're having trouble contacting us, please check here.
Site Updates
- Dec 4 2024 - 1:53pm
- Dec 4 2024 - 1:48pm
- Nov 19 2024 - 1:04pm
- Oct 17 2024 - 10:27am
- Jul 24 2024 - 1:22pm