Re: Creating temporary tables on the fly!!!

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 22 Jul 1999 20:43:45 +0800
Message-ID: <37971201.1AB5@yahoo.com>

charles wrote:
>
> I am a recent convert to Oracle and need to create and drop temporary tables
> on the fly for an Oracle 8 database (MS SQL Server 7 database migrated to
> Oracle 8 on WinNT - the SQL 7.0 table is created as a # table). This table
> will be accessed by the currently logged-in user and dropped by them when
> they have completed processing. The table will always have the same name
> i.e. it will be created and used by more than one user at any one time.
>
> Does anyone have a suggestion as to how I can achieve this?

Use dbms_sql (or execute_immediate in 8i)...

I dunno much about SQL Server but I've read on a newgroups before that temp tables in SQL server are often due to read consistency requirements, which are always there in oracle anyway - you may need the temp tables...?
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Thu Jul 22 1999 - 07:43:45 CDT