Variable related statements in SQL procedures

Variable related SQL statements are used to declare variables and to assign values to variables.

There are a few types of variable related statements:
  • DECLARE <variable> statement in SQL procedures
  • DECLARE <condition> statement in SQL procedures
  • DECLARE <condition handler> statement in SQL procedures
  • DECLARE CURSOR in SQL procedures
  • SET (assignment-statement) in SQL procedures

These statements provide the necessary support required to make use of the other types of SQL PL statements and SQL statements that will make use of variable values.