Last post Oct 16, 2017 08:34 PM by Lannie
Oct 15, 2017 01:49 PM|20141113|LINK
Oct 15, 2017 03:46 PM|mgebhard|LINK
I write so many update Sal scripts to execute. but I don't know where should I put the commit command ? just commit after each Sal script or I just commit one times after all sql script execute ?
A transaction is a logical set of statements that must complete as a group. If any of the statements fail, then all statements should rollback. We have no idea how your batch is designed and therefore cannot provide advice.
Consider reading Oracle Reference documentation.
Oct 16, 2017 08:34 PM|Lannie|LINK
Put at the end of each update statement if you are just using command line SQL to run one update at a time.