Board index » delphi » How can i create temporary tables with Oracle ?

How can i create temporary tables with Oracle ?

Is it possible to create temporary tables with Oracle. What's the SQL syntax
?

Best regards.

--
Benjamin Garcia.

 

Re:How can i create temporary tables with Oracle ?


try:
create your_temptable as
select t1.col1, t2.col1
from t1,
t2
where t1.key = t2.foreign_key
;
you can add the "unrecoverable" option to bypass the rollback
segments.
after working with that drop the table:
drop table your_temptable;

you use both statements with a tquery object and its execsql method.

yours

On Fri, 16 Jan 1998 05:41:48 +0100, "Benjamin Garcia"

Quote
<benja...@ordiges.be> wrote:
>Is it possible to create temporary tables with Oracle. What's the SQL syntax
>?

>Best regards.

Christian Kaas, c.k...@odn.de
Quote
>Software-, Projektrealisierung u. Beratung
>640kB ought to be enough memory ! - Bill Gates 1981

Other Threads