You can use the DECLARE LOCAL TEMPORARY TABLE statement:

    o  In interactive SQL

    o  In dynamic SQL as a statement to be dynamically executed

    o  In a stored module