Toad World® Forums

Oracle Temp Tables


#1

Hi - I’m new to Oracle coming from MS SQL SERVER. I’m having some trouble understanding how temp tables operate in Oracle - specifically, in SQL SERVER I’d create a temp table with something like the below and I’m trying to figure out the equivalent Oracle syntax. Thank you!

SELECT *
INTO #TEMP
FROM x


#2

Such syntax in Oracle would fail because of the hash, but without that, it would just create a normal table. The syntax is different for actual temporary tables in Oracle.

Example:

create global temporary table mytemptable
on commit preserve rows
as select * from myrealtable;

Oracle documentation explains various commit and storage options.

Cheers,
Russ


#3

Just what I was looking for, thank you!