Re: Temporary tables.
From: David <snapkad_at_post.cz>
Date: Tue, 31 Oct 2000 09:44:05 +0100
Message-ID: <39fe860f_at_news.cvut.cz>
Date: Tue, 31 Oct 2000 09:44:05 +0100
Message-ID: <39fe860f_at_news.cvut.cz>
if you're using Oracle 8i there's native support for temporary tables.
To create a temporary table:
CREATE GLOBAL TEMPORARY TABLE <table_name>
<normal table definition>
ON COMMIT [DELETE|PRESERVE] ROWS.
I haven't used it yet because we are running Oracle 7
HTH David Received on Tue Oct 31 2000 - 09:44:05 CET