asked
You executed this command to create a temporary table: (inside) What is true about the rows inserted into the REPORT_WORK_AREA table during a transaction after commit?
Hello, i need answer to this question. Thanks a lot. You executed this command to create a temporary table: SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area (startdate DATE, enddate DATE, class CHAR(20)) ON COMMIT PRESERVE ROWS; What is true about the rows inserted into the REPORT_WORK_AREA table during a transaction after commit?
What database management system is this for? That's not T-SQL syntax, so we're not talking about SQL Server.
Sounds a bit like homework or an interview question. My first stop would probably be to check the documentation -
http://docs.oracle.com/javadb/10.8.2.2/ref/rrefdeclaretemptable.html If that didn't work, I'd probably try looking on an internet search engine -
https://duckduckgo.com/?q=ON+COMMIT+PRESERVE+ROWS+site%3Aoracle-base.com Where have you tried to find the answer, so far? I see a previous question on this site that give a great hint as to the answer in the comments -
http://ask.sqlservercentral.com/questions/38083/global-temporary-tables.html
In Oracle, data rows in a global temporary table will either be SESSION based, in which data survives a commit but not a disconnect/reconnect, or they can be TRANSACTION based, in which data disappears after a commit. If the table was created as being SESSION-based, with "on commit preserve rows", then data will remain until the end of the current session. If it was created as being TRANSACTION- based with the "on commit delete rows" then it will remain until the next commit or rollback.
16 People are following this question.
