SQL: Local Temporary tables

---

Local temporary tables are distinct within modules and embedded SQL programs within SQL sessions.
The basic syntax is:

DECLARE LOCAL TEMPORARY TABLE table_name ( ...);