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
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
Just what I was looking for, thank you!