Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Reporting with dynamic sql

Re: Reporting with dynamic sql

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 16 Aug 2006 22:37:59 +0200
Message-ID: <gd07e2t2vfaj2smutscau9vnsd2ltaqj7e@4ax.com>


On 16 Aug 2006 13:05:17 -0700, "Deltones" <vibroverb_at_hotmail.com> wrote:

>
>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?

Yes,

But if you can't do without them you'd better follow the example of Mr Quesnel. This creates a temporary table in memory or temporary tablespace and the contents are automatically deleted on commit. So you need to create this table only once.

--
Sybrand Bakker, Senior Oracle DBA
Received on Wed Aug 16 2006 - 15:37:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US