The following syntax allows you to declare temporary local tables that exist only within the scope of the block. This allows the procedure to accumulate data to be returned to the caller for interim calculations. 

DECLARE TABLE <table_name> (<column_name> <data_type>(<p>, <s>)[, ...])

where:

table_name
Specifies the name of the temporary table to be declared.
column_name
Specifies the name of a column in the temporary table.
data_type
Specifies the data type, including the precision and scale, for the results of the function. See "Data types syntax" for a complete list of supported data types.