Table of ContentsPreviousNext

Ispirer
Please, note, that Ispirer SQLWays 6.0 is no longer supported and provided to clients.
You can try out automated conversion of databases and applications with Ispirer Toolkit for free. Download free trial.
Check out the relevant toolkit documentation.
Ispirer SQL Server to Oracle Migration overview.


Ispirer SQLWays Database Migration Software

COMMIT conversion from Microsoft SQL Server to Oracle

Microsoft SQL Server COMMIT can end implicit and explicit (nested) transactions, while Oracle COMMIT ends the current transaction. Therefore SQLWays removes the TRANSACTION clause and transaction name (variable) when converting COMMIT from Microsoft SQL Server to Oracle.

Examples:

TABLE 50. COMMIT conversion from Microsoft SQL Server to Oracle
Microsoft SQL Server
Oracle
COMMIT 
COMMIT; 
COMMIT TRAN 
COMMIT; 
COMMIT TRANSACTION 
COMMIT; 
COMMIT TRANSACTION tran1 
COMMIT; 
COMMIT TRANSACTION @val_tran1 
COMMIT; 


Table of ContentsPreviousNext
Copyright 1999-2023 Ispirer Systems.
Ispirer and SQLWays are registered trademarks. All other product names may be trademarks of the respective companies.
All rights reserved.