I'm trying to determine if our use of #TEMP tables in SQL Server 2000 will port to Oracle.
For instance, in SQL Server 2000 we do things like the following:
1) When a user runs a report where they can select a variable # of accounts and products, we will create 2 temp tables (#TEMPGEO and #TEMPPROD), containing the geo/prod keys that the user selected. We'll then run a query against the history table, joining #TEMPGEO and #TEMPROD. [All in one connection, obviously]. Can this approach be used in Oracle (both generally and with the same syntax]
2) Related question...in SQL Server, I can do this...
SELECT Invoice.* INTO #TempInvoices JOIN
WHERE
And then I can do a subsequent query against #TEMPINVOICES. I can even do this with SQL pass-through...again, can this be done in Oracle with the same syntax?
I guess my general question is whether this is part of the ANSI-92 standard, or if it's just something that's portable to Oracle...or are there minor differences in syntax.
Thanks,
Kevin