Re: tEMP TABLES IN oRACLE

From: Martijn Tonies <m.tonies_at_upscene.removethis.com>
Date: Tue, 18 Apr 2006 17:03:39 +0200
Message-ID: <1249vu5bcal4aa3@corp.supernews.com>

> I have table Dept.
> i want a temporary of structure same as Dept., so that temporary
> table can hold some records from dept. How to do this in oracle

If you're attempting to create tables that disappear after they are used, then it cannot be done in Oracle.

If you're trying to use storage for temporary data, look up the CREATE TABLE syntax in the documentation.

What is the problem you're trying to solve?

-- 
Martijn Tonies
Database Workbench - development tool for Oracle, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

Received on Tue Apr 18 2006 - 10:03:39 CDT