tag:blogger.com,1999:blog-7325550215422085906.post6878311060237734703..comments2024-03-28T12:51:00.793+05:30Comments on DATAWAREHOUSE CONCEPTS: AUTOCOMMIT in SQL- Simple and UsefulUnknownnoreply@blogger.comBlogger4125tag:blogger.com,1999:blog-7325550215422085906.post-41886347255193698842014-01-17T10:20:40.896+05:302014-01-17T10:20:40.896+05:30Whenever sqlerror then exit 1 rollback
Whenever os...Whenever sqlerror then exit 1 rollback<br />Whenever oserror then exit 1 rollbackDanohttps://www.blogger.com/profile/06070316169199797571noreply@blogger.comtag:blogger.com,1999:blog-7325550215422085906.post-34315236682654631252014-01-16T12:42:12.391+05:302014-01-16T12:42:12.391+05:30following on from Cepren - sorry for the spelling ...following on from Cepren - sorry for the spelling - it is important to know that "autocommit" is a tool feature and not an Oracle feature - although I believe it is a feature of MySQL.<br />It is a quite dangerous feature and one that I always disable. <br />When doing data corrections I will run a series of inserts/updates/deletes with query checks in between so that at the end I can commit the whole transaction set knowing that it is all correct. <br />If I am unhappy about anything I can rollback everything and start again.<br />In the meantime other users have no knowledge of these actions until I have finally committed.<br />I would argue that commit should always be a positively decided action. If you are in a busy rushed environment then with autocommit on mistakes can easily happen. <br />With it off you have more chance to think before commit.Rod Cordereyhttp://www.lane-associates.comnoreply@blogger.comtag:blogger.com,1999:blog-7325550215422085906.post-29980806811184246032013-12-27T13:02:13.287+05:302013-12-27T13:02:13.287+05:30nice example for autocommit;nice example for autocommit;Sumanhttps://www.blogger.com/profile/07426543648611714326noreply@blogger.comtag:blogger.com,1999:blog-7325550215422085906.post-60081957484870042662013-12-20T14:04:56.967+05:302013-12-20T14:04:56.967+05:30Autocommit is a option of the SQL*Plus, so it can ...Autocommit is a option of the SQL*Plus, so it can be turned on in that tool only. The article does not say anything about it.Anonymoushttps://www.blogger.com/profile/01300027060243100326noreply@blogger.com