You can use the DECLARE statement:

    o  In interactive SQL

    o  In dynamic SQL as a statement to be dynamically executed