Re: create temp table

"Wafflart S�bastien" wrote:
> Microsoft SQL server has function wish allow to create temp table:
>
> select * from table into #table_temp
>
> Does exist a same function in Oracle database ?

Sure, you'd just do this in SQL*Plus:

	create table <temp_table_name> as (
		select * from <source_table_name>
	);

Replacing, obviously, the angle brackets and their contents with the temporary table name and the source table name, respectively.

cheers,
bob :)
Oracle Applications Administrator Received on Mon Jan 24 2000 - 18:25:46 CET