Re: SQL Server to Oracle

Creating and dropping tables "on the fly" is not appropriate in Oracle, 
though I understand it is common practise in SQL Server.  Oracle has 
a "global temporary table" for temporary data.  You would create it ONCE, 
PERMANENTLY just like any other table:

CREATE GLOBAL TEMPORARY TABLE table1
	(column1 varchar(17) NOT NULL,
	 column2 nvarchar(30) NULL);

In your applications you can then INSERT data into this table.  The data 
will be visible only to the session that inserted it, and will be deleted 
automatically when the session COMMITs (or when the session disconnects if 
the "ON COMMIT PRESERVE ROWS" option is used when creating the table).

---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].