Temp tables

Does Oracle support temp tables?

For example, on certain servers, I can say:

SELECT *
INTO #myTempTable
FROM EMP This creates a temporary table named #myTempTable that is automatically dropped when the session terminates.

Does Oracle support something like this?

Thanks in advance! Received on Tue Mar 09 1999 - 12:29:05 CST