{"id":14135,"date":"2024-03-15T08:32:07","date_gmt":"2024-03-15T08:32:07","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-do-you-add-multiple-rows-of-data-at-the-same-time-in-oracle\/"},"modified":"2025-08-06T04:21:04","modified_gmt":"2025-08-06T04:21:04","slug":"how-do-you-add-multiple-rows-of-data-at-the-same-time-in-oracle","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-do-you-add-multiple-rows-of-data-at-the-same-time-in-oracle\/","title":{"rendered":"Insert Multiple Rows Oracle: INSERT ALL Guide"},"content":{"rendered":"<p>One option could be:<br \/>\nTo simultaneously add multiple lines of data to an Oracle database, you can use the INSERT ALL statement.<\/p>\n<p>The INSERT ALL statement allows for the insertion of multiple rows into one or more tables at once. Here is the basic syntax for the INSERT ALL statement:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">INSERT<\/span> <span class=\"hljs-keyword\">ALL<\/span>\r\n  <span class=\"hljs-keyword\">INTO<\/span> table_name (column1, column2, ...)\r\n    <span class=\"hljs-keyword\">VALUES<\/span> (value1, value2, ...)\r\n  <span class=\"hljs-keyword\">INTO<\/span> table_name (column1, column2, ...)\r\n    <span class=\"hljs-keyword\">VALUES<\/span> (value1, value2, ...)\r\n  ...\r\n<span class=\"hljs-keyword\">SELECT<\/span> <span class=\"hljs-operator\">*<\/span> <span class=\"hljs-keyword\">FROM<\/span> dual;\r\n<\/code><\/pre>\n<p>In this case, table_name refers to the table where data will be inserted, column1, column2, etc. are the column names where data will be inserted, and value1, value2, etc. are the specific values to be inserted.<\/p>\n<p>Here is a specific example:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">INSERT<\/span> <span class=\"hljs-keyword\">ALL<\/span>\r\n  <span class=\"hljs-keyword\">INTO<\/span> employees (employee_id, first_name, last_name)\r\n    <span class=\"hljs-keyword\">VALUES<\/span> (<span class=\"hljs-number\">1001<\/span>, <span class=\"hljs-string\">'John'<\/span>, <span class=\"hljs-string\">'Doe'<\/span>)\r\n  <span class=\"hljs-keyword\">INTO<\/span> employees (employee_id, first_name, last_name)\r\n    <span class=\"hljs-keyword\">VALUES<\/span> (<span class=\"hljs-number\">1002<\/span>, <span class=\"hljs-string\">'Jane'<\/span>, <span class=\"hljs-string\">'Smith'<\/span>)\r\n  <span class=\"hljs-keyword\">INTO<\/span> employees (employee_id, first_name, last_name)\r\n    <span class=\"hljs-keyword\">VALUES<\/span> (<span class=\"hljs-number\">1003<\/span>, <span class=\"hljs-string\">'Mike'<\/span>, <span class=\"hljs-string\">'Johnson'<\/span>)\r\n<span class=\"hljs-keyword\">SELECT<\/span> <span class=\"hljs-operator\">*<\/span> <span class=\"hljs-keyword\">FROM<\/span> dual;\r\n<\/code><\/pre>\n<p>This example will insert three rows of data into the employees table at the same time.<\/p>\n<p>Please note that all INSERT statements must end with SELECT * FROM dual; This is a specific requirement of Oracle.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>One option could be: To simultaneously add multiple lines of data to an Oracle database, you can use the INSERT ALL statement. The INSERT ALL statement allows for the insertion of multiple rows into one or more tables at once. Here is the basic syntax for the INSERT ALL statement: INSERT ALL INTO table_name (column1, [&hellip;]<\/p>\n","protected":false},"author":12,"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":[494,7989,19037,472,1116],"class_list":["post-14135","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-database-optimization","tag-insert-all","tag-multiple-rows-insert","tag-oracle-sql","tag-oracle-tips"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Insert Multiple Rows Oracle: INSERT ALL Guide - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn how to efficiently insert multiple rows in Oracle using INSERT ALL. Step-by-step guide with syntax example.\" \/>\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-do-you-add-multiple-rows-of-data-at-the-same-time-in-oracle\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Insert Multiple Rows Oracle: INSERT ALL Guide\" \/>\n<meta property=\"og:description\" content=\"Learn how to efficiently insert multiple rows in Oracle using INSERT ALL. Step-by-step guide with syntax example.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-do-you-add-multiple-rows-of-data-at-the-same-time-in-oracle\/\" \/>\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-15T08:32:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-06T04:21:04+00:00\" \/>\n<meta name=\"author\" content=\"Liam\" \/>\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=\"Liam\" \/>\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-do-you-add-multiple-rows-of-data-at-the-same-time-in-oracle\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-you-add-multiple-rows-of-data-at-the-same-time-in-oracle\/\"},\"author\":{\"name\":\"Liam\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/23786905eb7b377f45ddb01c17da7671\"},\"headline\":\"Insert Multiple Rows Oracle: INSERT ALL Guide\",\"datePublished\":\"2024-03-15T08:32:07+00:00\",\"dateModified\":\"2025-08-06T04:21:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-you-add-multiple-rows-of-data-at-the-same-time-in-oracle\/\"},\"wordCount\":134,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"database optimization\",\"INSERT ALL\",\"Multiple Rows Insert\",\"Oracle SQL\",\"Oracle tips\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-you-add-multiple-rows-of-data-at-the-same-time-in-oracle\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-do-you-add-multiple-rows-of-data-at-the-same-time-in-oracle\/\",\"name\":\"Insert Multiple Rows Oracle: INSERT ALL Guide - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T08:32:07+00:00\",\"dateModified\":\"2025-08-06T04:21:04+00:00\",\"description\":\"Learn how to efficiently insert multiple rows in Oracle using INSERT ALL. Step-by-step guide with syntax example.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-you-add-multiple-rows-of-data-at-the-same-time-in-oracle\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-do-you-add-multiple-rows-of-data-at-the-same-time-in-oracle\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-you-add-multiple-rows-of-data-at-the-same-time-in-oracle\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Insert Multiple Rows Oracle: INSERT ALL Guide\"}]},{\"@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\/23786905eb7b377f45ddb01c17da7671\",\"name\":\"Liam\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g\",\"caption\":\"Liam\"},\"sameAs\":[\"http:\/\/Wilson\"],\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/liamwilson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Insert Multiple Rows Oracle: INSERT ALL Guide - Blog - Silicon Cloud","description":"Learn how to efficiently insert multiple rows in Oracle using INSERT ALL. Step-by-step guide with syntax example.","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-do-you-add-multiple-rows-of-data-at-the-same-time-in-oracle\/","og_locale":"en_US","og_type":"article","og_title":"Insert Multiple Rows Oracle: INSERT ALL Guide","og_description":"Learn how to efficiently insert multiple rows in Oracle using INSERT ALL. Step-by-step guide with syntax example.","og_url":"https:\/\/www.silicloud.com\/blog\/how-do-you-add-multiple-rows-of-data-at-the-same-time-in-oracle\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T08:32:07+00:00","article_modified_time":"2025-08-06T04:21:04+00:00","author":"Liam","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Liam","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-do-you-add-multiple-rows-of-data-at-the-same-time-in-oracle\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-do-you-add-multiple-rows-of-data-at-the-same-time-in-oracle\/"},"author":{"name":"Liam","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/23786905eb7b377f45ddb01c17da7671"},"headline":"Insert Multiple Rows Oracle: INSERT ALL Guide","datePublished":"2024-03-15T08:32:07+00:00","dateModified":"2025-08-06T04:21:04+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-do-you-add-multiple-rows-of-data-at-the-same-time-in-oracle\/"},"wordCount":134,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["database optimization","INSERT ALL","Multiple Rows Insert","Oracle SQL","Oracle tips"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-do-you-add-multiple-rows-of-data-at-the-same-time-in-oracle\/","url":"https:\/\/www.silicloud.com\/blog\/how-do-you-add-multiple-rows-of-data-at-the-same-time-in-oracle\/","name":"Insert Multiple Rows Oracle: INSERT ALL Guide - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T08:32:07+00:00","dateModified":"2025-08-06T04:21:04+00:00","description":"Learn how to efficiently insert multiple rows in Oracle using INSERT ALL. Step-by-step guide with syntax example.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-do-you-add-multiple-rows-of-data-at-the-same-time-in-oracle\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-do-you-add-multiple-rows-of-data-at-the-same-time-in-oracle\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-do-you-add-multiple-rows-of-data-at-the-same-time-in-oracle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Insert Multiple Rows Oracle: INSERT ALL Guide"}]},{"@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\/23786905eb7b377f45ddb01c17da7671","name":"Liam","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g","caption":"Liam"},"sameAs":["http:\/\/Wilson"],"url":"https:\/\/www.silicloud.com\/blog\/author\/liamwilson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/14135","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\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=14135"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/14135\/revisions"}],"predecessor-version":[{"id":158157,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/14135\/revisions\/158157"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=14135"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=14135"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=14135"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}