​
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