15.10 - DECLARE - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

Keyword introducing a local variable declaration, cursor declaration, or condition handler declaration statement.

DECLARE is followed by a list of local variables, a cursor specification, or a list of handler declarations.

You can specify multiple local variable declarations, cursor declarations, or condition handler declarations for each procedure.

See SQL Stored Procedures and Embedded SQL, B035-1148 for details.