Help Center> Data Warehouse Service> Tool Guide> DSC - SQL Syntax Migration Tool> SQL Syntax Migration Reference> Oracle Syntax Migration (GaussDB A)> Temporary Tables
Temporary Tables
GaussDB(DWS) do not support GLOBAL TEMPORARY TABLE. Hence, this has been handled using LOCAL TEMPORARY TABLE.
Similarly, ON COMMIT DELETE ROWS is also not supported. This has been handled using ON COMMIT PRESERVE ROWS.
Figure 1 Input - Temporary tables
Figure 2 Output - Temporary tables
Parent topic: Oracle Syntax Migration (GaussDB A)
Last Article: SYS_GUID
Next Article: Global Temporary Tables
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.