{"id":22176,"date":"2013-05-13T10:42:25","date_gmt":"2013-05-13T05:12:25","guid":{"rendered":"http:\/\/vskills.in\/certification\/tutorial\/?p=22176"},"modified":"2024-04-12T14:16:48","modified_gmt":"2024-04-12T08:46:48","slug":"commit-and-rollback","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/commit-and-rollback\/","title":{"rendered":"Commit and rollback"},"content":{"rendered":"\n<p><strong>Commit and rollback in PL\/SQL<\/strong><\/p>\n\n\n\n<p>In PL\/SQL, the COMMIT and ROLLBACK statements are used to manage transactions. A transaction is a sequence of one or more SQL statements that are treated as a single unit of work. The COMMIT statement is used to make permanent changes to the database, while the ROLLBACK statement is used to undo changes and return the database to its previous state.<\/p>\n\n\n\n<p>Here&#8217;s how you can use the COMMIT and ROLLBACK statements in PL\/SQL:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DECLARE\r\n  -- declare variables here\r\nBEGIN\r\n  -- perform database operations here\r\n  INSERT INTO employees (id, name, department)\r\n  VALUES (1, 'John Doe', 'Sales');\r\n  \r\n  INSERT INTO departments (id, name)\r\n  VALUES (1, 'Sales');\r\n  \r\n  -- commit the changes\r\n  COMMIT;\r\nEXCEPTION\r\n  -- handle any exceptions here\r\n  WHEN OTHERS THEN\r\n    -- rollback the transaction\r\n    ROLLBACK;\r\nEND;\r<\/code><\/pre>\n\n\n\n<p>In this example, we are performing two database operations (inserting a record into the &#8220;employees&#8221; table and the &#8220;departments&#8221; table). After the operations are complete, we use the COMMIT statement to commit the changes to the database. If an exception is raised during the execution of the code, the ROLLBACK statement is used to undo any changes that were made to the database.<\/p>\n\n\n\n<p>The COMMIT statement has the following syntax:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">COMMIT;\r<\/pre>\n\n\n\n<p>This statement is used to commit the current transaction and make all changes permanent.<\/p>\n\n\n\n<p>The ROLLBACK statement has the following syntax:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ROLLBACK;<\/pre>\n\n\n\n<p>This statement is used to undo all changes made in the current transaction and return the database to its previous state.<\/p>\n\n\n\n<p>It&#8217;s important to note that transactions are automatically committed when a PL\/SQL block is completed, unless a ROLLBACK statement has been executed. Therefore, it&#8217;s a good practice to always explicitly use the COMMIT and ROLLBACK statements in your PL\/SQL code to ensure data integrity and consistency.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Apply for PL\/SQL Certification<\/strong><\/h2>\n\n\n\n<p><a href=\"https:\/\/www.vskills.in\/certification\/certified-pl-sql-developer\">https:\/\/www.vskills.in\/certification\/certified-pl-sql-developer<\/a><\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong><a href=\"https:\/\/www.vskills.in\/certification\/tutorial\/pl-sql-developer\/\" target=\"_blank\" rel=\"noreferrer noopener\">Back to Tutorials<\/a><\/strong><\/h4>\n","protected":false},"excerpt":{"rendered":"<p>Commit and rollback in PL\/SQL In PL\/SQL, the COMMIT and ROLLBACK statements are used to manage transactions. A transaction is a sequence of one or more SQL statements that are treated as a single unit of work. The COMMIT statement is used to make permanent changes to the database, while the ROLLBACK statement is used&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"categories":[288],"tags":[],"class_list":["post-22176","page","type-page","status-publish","hentry","category-pl-sql"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Commit and rollback tutorials<\/title>\n<meta name=\"description\" content=\"Commit and rollback tutorials\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.vskills.in\/certification\/tutorial\/commit-and-rollback\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Commit and rollback tutorials\" \/>\n<meta property=\"og:description\" content=\"Commit and rollback tutorials\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/commit-and-rollback\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutorial\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/vskills.in\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-12T08:46:48+00:00\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/commit-and-rollback\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/commit-and-rollback\/\",\"name\":\"Commit and rollback tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\"},\"datePublished\":\"2013-05-13T05:12:25+00:00\",\"dateModified\":\"2024-04-12T08:46:48+00:00\",\"description\":\"Commit and rollback tutorials\",\"breadcrumb\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/commit-and-rollback\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vskills.in\/certification\/tutorial\/commit-and-rollback\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/commit-and-rollback\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Commit and rollback\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"name\":\"Tutorial\",\"description\":\"Vskills - A initiative in elearning and certification\",\"publisher\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\",\"name\":\"Vskills\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"contentUrl\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"width\":73,\"height\":55,\"caption\":\"Vskills\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/vskills.in\/\",\"https:\/\/x.com\/vskills_in\",\"https:\/\/www.linkedin.com\/company-beta\/1371554\/\",\"https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Commit and rollback tutorials","description":"Commit and rollback tutorials","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.vskills.in\/certification\/tutorial\/commit-and-rollback\/","og_locale":"en_US","og_type":"article","og_title":"Commit and rollback tutorials","og_description":"Commit and rollback tutorials","og_url":"https:\/\/www.vskills.in\/certification\/tutorial\/commit-and-rollback\/","og_site_name":"Tutorial","article_publisher":"https:\/\/www.facebook.com\/vskills.in\/","article_modified_time":"2024-04-12T08:46:48+00:00","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/commit-and-rollback\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/commit-and-rollback\/","name":"Commit and rollback tutorials","isPartOf":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website"},"datePublished":"2013-05-13T05:12:25+00:00","dateModified":"2024-04-12T08:46:48+00:00","description":"Commit and rollback tutorials","breadcrumb":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/commit-and-rollback\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vskills.in\/certification\/tutorial\/commit-and-rollback\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/commit-and-rollback\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vskills.in\/certification\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Commit and rollback"}]},{"@type":"WebSite","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","name":"Tutorial","description":"Vskills - A initiative in elearning and certification","publisher":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization","name":"Vskills","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","contentUrl":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","width":73,"height":55,"caption":"Vskills"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/vskills.in\/","https:\/\/x.com\/vskills_in","https:\/\/www.linkedin.com\/company-beta\/1371554\/","https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw"]}]}},"_links":{"self":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/22176","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/comments?post=22176"}],"version-history":[{"count":5,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/22176\/revisions"}],"predecessor-version":[{"id":129933,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/22176\/revisions\/129933"}],"wp:attachment":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/media?parent=22176"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/categories?post=22176"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/tags?post=22176"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}