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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Temporary tables inside procedure

Re: Temporary tables inside procedure

From: Alex Gorbachev <gorbyx_at_gmail.com>
Date: Fri, 28 Jul 2006 18:54:37 +0200
Message-ID: <c2213f680607280954l5cc24659y6ea1c1a5fcc71dc7@mail.gmail.com>


Global temporary tables are exactly for that purpose unless you see limitaions in your case. The only advice - don't truncate them. Truncate on GTT causes contention when done by many processes (at least that's the case with 9.2.0.5).

2006/7/28, Harvinder Singh <Harvinder.Singh_at_metratech.com>:
> Hi,
>
> We have to port sql server procedures to pl/sql, In some SQL Server procedures the temp table is created inside the procedure and populated with data and then truncated at the end, in oracle we can create global temporary tables outside procedure and use them but we are wondering if there is any other better way to do this in oracle.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Best regards,
Alex Gorbachev

http://blog.oracloid.com
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jul 28 2006 - 11:54:37 CDT

Original text of this message

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