Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Question on temporary table?
There are several ways in which to handle the issue.
Here are two:
1. Create a procedure which handle the table creation dynamically. (Use
dbms_sql package to run the ddl
2. You can make use of pl/sql tables (work like arrays ) If the data is
going to be used by the same session
Shelby
In article <7hceu6$g1q$1_at_nnrp1.deja.com>,
rong_at_my-dejanews.com wrote:
> Hi All,
>
> I have a question regarding temporary table. On SQL Server, it
provides
> the feature of using temporary table. I have a performance issue which
> needs temporary table to solve it. In my case, I prefer to create the
> local temporary table. But on Oracle, there's no way to create the
> temporary table. But I may create a table for a short period and drop
> it after the application is over. But the thing is I have to be
granted
> the right to create the table. During the running of application, we
> don't know who is gonna be the user. Therefore, we don't know for sure
> if the user has the privilege to create the table or not. I think
there
> must be a way on Oracle to deal with the temporary table issue
somehow.
> Can any body give me any good suggestion on this issue. Thanks for
your
> response.
>
> Rita
>
> --== Sent via Deja.com http://www.deja.com/ ==--
> ---Share what you know. Learn what you don't.---
>
--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Wed May 12 1999 - 13:18:53 CDT