Re: Reporting with dynamic sql

From: Deltones <vibroverb_at_hotmail.com>
Date: 16 Aug 2006 13:05:17 -0700
Message-ID: <1155758717.356776.311100@h48g2000cwc.googlegroups.com>

G Quesnel wrote:
> BTW / just a little side note - you are not using TEMP tables. You are
> creating regular tables, and that is why multiple sessions can see data
> from other sessions.
> A temporary table would be created with something like ...
> Create global temporary table T1 (c1 number ....) on commit delete rows;

These tables are dropped at the end of the script. That's why I call them temp table. But from what I gather from this thread, it's probably not a good idea to create them in the first place, regular tables or true temp tables. Right? Received on Wed Aug 16 2006 - 15:05:17 CDT