DECLARE statement

Declares a SQL variable or an exception within a compound statement (BEGIN...END).

 Syntax 1: Declaring a variable
 Syntax 2: Declaring an exception
 Remarks
 See also
 Standards and compatibility
 Example