{"id":6314,"date":"2024-03-14T04:06:35","date_gmt":"2024-03-14T04:06:35","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-update-multiple-rows-of-data-in-oracle-at-once\/"},"modified":"2025-08-02T02:00:17","modified_gmt":"2025-08-02T02:00:17","slug":"how-to-update-multiple-rows-of-data-in-oracle-at-once","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-update-multiple-rows-of-data-in-oracle-at-once\/","title":{"rendered":"Update Multiple Rows in Oracle: Bulk Methods"},"content":{"rendered":"

In Oracle, to update multiple rows of data in bulk, one of the following methods can be used:<\/p>\n

    \n
  1. By using the MERGE statement, you can achieve insertion, updating, and deletion operations. You can merge multiple update statements into one MERGE statement to batch update multiple records. The following is an example code snippet.<\/li>\n<\/ol>\n
    MERGE INTO table_name dest\r\nUSING (SELECT id, new_value FROM updated_data) src\r\nON (dest.id = src.id)\r\nWHEN MATCHED THEN UPDATE SET dest.column_name = src.new_value;\r\n<\/code><\/pre>\n
      \n
    1. You can use a PL\/SQL loop to update data one by one and then batch execute multiple update operations through the FORALL statement. Here is an example code:<\/li>\n<\/ol>\n
      DECLARE\r\n    TYPE id_table IS TABLE OF table_name.id%TYPE INDEX BY PLS_INTEGER;\r\n    TYPE value_table IS TABLE OF table_name.column_name%TYPE INDEX BY PLS_INTEGER;\r\n    \r\n    ids id_table;\r\n    values value_table;\r\nBEGIN\r\n    -- \u586b\u5145ids\u548cvalues\u6570\u7ec4\r\n    \r\n    FOR i IN 1..ids.COUNT LOOP\r\n        UPDATE table_name\r\n        SET column_name = values(i)\r\n        WHERE id = ids(i);\r\n    END LOOP;\r\nEND;\r\n<\/code><\/pre>\n
      Both methods can be used to achieve batch updating multiple records in an Oracle database.<\/p>\n","protected":false},"excerpt":{"rendered":"
      In Oracle, to update multiple rows of data in bulk, one of the following methods can be used: By using the MERGE statement, you can achieve insertion, updating, and deletion operations. You can merge multiple update statements into one MERGE statement to batch update multiple records. The following is an example code snippet. MERGE INTO […]<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[1284,3064,494,7555,472],"class_list":["post-6314","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-batch-processing","tag-bulk-update","tag-database-optimization","tag-merge-statement","tag-oracle-sql"],"yoast_head":"\nUpdate Multiple Rows in Oracle: Bulk Methods - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Efficiently update multiple Oracle rows at once using MERGE & bulk operations. Simplify database updates with these techniques.\" \/>\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.silicloud.com\/blog\/how-to-update-multiple-rows-of-data-in-oracle-at-once\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Update Multiple Rows in Oracle: Bulk Methods\" \/>\n<meta property=\"og:description\" content=\"Efficiently update multiple Oracle rows at once using MERGE & bulk operations. Simplify database updates with these techniques.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-update-multiple-rows-of-data-in-oracle-at-once\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-14T04:06:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-02T02:00:17+00:00\" \/>\n<meta name=\"author\" content=\"Ava Mitchell\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ava Mitchell\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-update-multiple-rows-of-data-in-oracle-at-once\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-update-multiple-rows-of-data-in-oracle-at-once\/\"},\"author\":{\"name\":\"Ava Mitchell\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64\"},\"headline\":\"Update Multiple Rows in Oracle: Bulk Methods\",\"datePublished\":\"2024-03-14T04:06:35+00:00\",\"dateModified\":\"2025-08-02T02:00:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-update-multiple-rows-of-data-in-oracle-at-once\/\"},\"wordCount\":104,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"batch processing\",\"bulk update\",\"database optimization\",\"MERGE statement\",\"Oracle SQL\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-update-multiple-rows-of-data-in-oracle-at-once\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-update-multiple-rows-of-data-in-oracle-at-once\/\",\"name\":\"Update Multiple Rows in Oracle: Bulk Methods - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T04:06:35+00:00\",\"dateModified\":\"2025-08-02T02:00:17+00:00\",\"description\":\"Efficiently update multiple Oracle rows at once using MERGE & bulk operations. Simplify database updates with these techniques.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-update-multiple-rows-of-data-in-oracle-at-once\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-update-multiple-rows-of-data-in-oracle-at-once\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-update-multiple-rows-of-data-in-oracle-at-once\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Update Multiple Rows in Oracle: Bulk Methods\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64\",\"name\":\"Ava Mitchell\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g\",\"caption\":\"Ava Mitchell\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/avamitchell\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Update Multiple Rows in Oracle: Bulk Methods - Blog - Silicon Cloud","description":"Efficiently update multiple Oracle rows at once using MERGE & bulk operations. Simplify database updates with these techniques.","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.silicloud.com\/blog\/how-to-update-multiple-rows-of-data-in-oracle-at-once\/","og_locale":"en_US","og_type":"article","og_title":"Update Multiple Rows in Oracle: Bulk Methods","og_description":"Efficiently update multiple Oracle rows at once using MERGE & bulk operations. Simplify database updates with these techniques.","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-update-multiple-rows-of-data-in-oracle-at-once\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T04:06:35+00:00","article_modified_time":"2025-08-02T02:00:17+00:00","author":"Ava Mitchell","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Ava Mitchell","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-update-multiple-rows-of-data-in-oracle-at-once\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-update-multiple-rows-of-data-in-oracle-at-once\/"},"author":{"name":"Ava Mitchell","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64"},"headline":"Update Multiple Rows in Oracle: Bulk Methods","datePublished":"2024-03-14T04:06:35+00:00","dateModified":"2025-08-02T02:00:17+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-update-multiple-rows-of-data-in-oracle-at-once\/"},"wordCount":104,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["batch processing","bulk update","database optimization","MERGE statement","Oracle SQL"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-update-multiple-rows-of-data-in-oracle-at-once\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-update-multiple-rows-of-data-in-oracle-at-once\/","name":"Update Multiple Rows in Oracle: Bulk Methods - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T04:06:35+00:00","dateModified":"2025-08-02T02:00:17+00:00","description":"Efficiently update multiple Oracle rows at once using MERGE & bulk operations. Simplify database updates with these techniques.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-update-multiple-rows-of-data-in-oracle-at-once\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-update-multiple-rows-of-data-in-oracle-at-once\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-update-multiple-rows-of-data-in-oracle-at-once\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Update Multiple Rows in Oracle: Bulk Methods"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64","name":"Ava Mitchell","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g","caption":"Ava Mitchell"},"url":"https:\/\/www.silicloud.com\/blog\/author\/avamitchell\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/6314","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=6314"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/6314\/revisions"}],"predecessor-version":[{"id":151075,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/6314\/revisions\/151075"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=6314"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=6314"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=6314"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}