"Commit" is something used by the database to commit the changes. When you're working in TOAD, you're not actually modifying the underlying data. You're basically running in a session scope, and TOAD and Oracle are saving the changes you are making throughout the session. So, for example, if you delete something you didn't mean to delete, you can actually do the opposite of commit, which is to "rollback" (right next to the commit button in TOAD).
Many clients have an implied commit when you break the connection. TOAD gives you the option of commiting automatically, being prompted, or rolling back. You can use commit and rollback within stored procs, too - so if you're running several queries that rely on each other, if one fails, you can rollback the others. Commit and rollback are important concepts to grasp. :) -d On 11/4/05, Cornillon, Matthieu (Consultant) <[EMAIL PROTECTED]> wrote: > > Russ, > > > Now, I hardly know what the commit command does. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223270 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
