Each scalar declaration statement can declare one or more variables
DECLARE <scalar_name> [, ...] <data_type> [DEFAULT <value>]
scalar_name
specifies the name for the scalar variable. You can define multiple variables by separating the names with a comma.
data_type
specifies the data type, including the precision and scale, for to be declared for the variable. See "Data types syntax" for a complete list of supported data types.
value
(optional) specifies the default value assigned to the scalar variable.