Skip to main content

​
Synopsis

DECLARE identifier [, ...] type [ DEFAULT expression ]

​
Description

Use the DECLARE statement directly after the begin keyword in routines to define one or more variables with an identifier as name.

​
Examples

A simple declaration of the variable x with the tinyint data type and the implicit default value of null: 
DECLARE x tinyint;
A declaration of multiple string variables with length restricted to 25 characters: 
DECLARE first_name, last_name, middle_name varchar(25);
A declaration of an exact decimal number with a default value: 
DECLARE uptime_requirement decimal DEFAULT 99.999;
A declaration with a default value from an expression: 
DECLARE start_time timestamp(3) with time zone DEFAULT now();
Further examples of varying complexity that cover usage of the DECLARE statement in combination with other statements are available in the SQL routines examples documentation.

​
See also