this is the default and when the session issues a COMMIT the table is truncated. Remember that only THIS sessions data is removed. Data for other sessions is unaffected.
ON COMMIT DELETE ROWS
Then the data is not deleted automatically until the session ends. Of course the user can delete or truncate it manually at any time.
ON COMMIT PRESERVE ROWS
926165 wrote:Just my 2 cents here.
I am trying to convert a MSSQL Database to Oracle 11g. But I am a little bit stuck on Dynamic temp tables in stored Procedures.