COMMIT conversion from Microsoft SQL Server to Oracle

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; 

Microsoft SQL Server	Oracle
COMMIT	COMMIT;
COMMIT TRAN	COMMIT;
COMMIT TRANSACTION	COMMIT;
COMMIT TRANSACTION tran1	COMMIT;
COMMIT TRANSACTION @val_tran1	COMMIT;