{"id":7846,"date":"2024-03-14T07:10:22","date_gmt":"2024-03-14T07:10:22","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-can-multiple-rows-be-merged-into-one-column-in-oracle\/"},"modified":"2025-08-02T21:31:11","modified_gmt":"2025-08-02T21:31:11","slug":"how-can-multiple-rows-be-merged-into-one-column-in-oracle","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-can-multiple-rows-be-merged-into-one-column-in-oracle\/","title":{"rendered":"Merge Multiple Rows into One Column in Oracle"},"content":{"rendered":"<p>You can use the LISTAGG function in Oracle to merge values from multiple rows into one row. Here is an example:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">SELECT<\/span> deptno, <span class=\"hljs-built_in\">LISTAGG<\/span>(ename, <span class=\"hljs-string\">', '<\/span>) <span class=\"hljs-keyword\">WITHIN<\/span> <span class=\"hljs-keyword\">GROUP<\/span> (<span class=\"hljs-keyword\">ORDER<\/span> <span class=\"hljs-keyword\">BY<\/span> ename) <span class=\"hljs-keyword\">AS<\/span> employees\r\n<span class=\"hljs-keyword\">FROM<\/span> emp\r\n<span class=\"hljs-keyword\">GROUP<\/span> <span class=\"hljs-keyword\">BY<\/span> deptno;\r\n<\/code><\/pre>\n<p>In the example above, we selected the department number (deptno) and employee name (ename) from the employee table (emp), then used the LISTAGG function to merge the names of employees in the same department into a single string separated by commas. Finally, we grouped the results by department number using the GROUP BY clause.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>You can use the LISTAGG function in Oracle to merge values from multiple rows into one row. Here is an example: SELECT deptno, LISTAGG(ename, &#8216;, &#8216;) WITHIN GROUP (ORDER BY ename) AS employees FROM emp GROUP BY deptno; In the example above, we selected the department number (deptno) and employee name (ename) from the employee [&hellip;]<\/p>\n","protected":false},"author":14,"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":[830,5020,10221,472,10222],"class_list":["post-7846","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-database-tutorial","tag-listagg","tag-merge-rows","tag-oracle-sql","tag-sql-aggregation"],"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>Merge Multiple Rows into One Column in Oracle - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn how to merge multiple rows into one column in Oracle using LISTAGG function with step-by-step examples.\" \/>\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-can-multiple-rows-be-merged-into-one-column-in-oracle\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Merge Multiple Rows into One Column in Oracle\" \/>\n<meta property=\"og:description\" content=\"Learn how to merge multiple rows into one column in Oracle using LISTAGG function with step-by-step examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-can-multiple-rows-be-merged-into-one-column-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-14T07:10:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-02T21:31:11+00:00\" \/>\n<meta name=\"author\" content=\"Noah Thompson\" \/>\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=\"Noah Thompson\" \/>\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-can-multiple-rows-be-merged-into-one-column-in-oracle\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-multiple-rows-be-merged-into-one-column-in-oracle\/\"},\"author\":{\"name\":\"Noah Thompson\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/2e83cc6ab9f60d36921c2d0f9f280f4a\"},\"headline\":\"Merge Multiple Rows into One Column in Oracle\",\"datePublished\":\"2024-03-14T07:10:22+00:00\",\"dateModified\":\"2025-08-02T21:31:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-multiple-rows-be-merged-into-one-column-in-oracle\/\"},\"wordCount\":83,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"database tutorial\",\"LISTAGG\",\"Merge Rows\",\"Oracle SQL\",\"SQL Aggregation\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-multiple-rows-be-merged-into-one-column-in-oracle\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-can-multiple-rows-be-merged-into-one-column-in-oracle\/\",\"name\":\"Merge Multiple Rows into One Column in Oracle - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T07:10:22+00:00\",\"dateModified\":\"2025-08-02T21:31:11+00:00\",\"description\":\"Learn how to merge multiple rows into one column in Oracle using LISTAGG function with step-by-step examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-multiple-rows-be-merged-into-one-column-in-oracle\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-can-multiple-rows-be-merged-into-one-column-in-oracle\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-multiple-rows-be-merged-into-one-column-in-oracle\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Merge Multiple Rows into One Column in Oracle\"}]},{\"@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\/2e83cc6ab9f60d36921c2d0f9f280f4a\",\"name\":\"Noah Thompson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g\",\"caption\":\"Noah Thompson\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/noahthompson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Merge Multiple Rows into One Column in Oracle - Blog - Silicon Cloud","description":"Learn how to merge multiple rows into one column in Oracle using LISTAGG function with step-by-step examples.","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-can-multiple-rows-be-merged-into-one-column-in-oracle\/","og_locale":"en_US","og_type":"article","og_title":"Merge Multiple Rows into One Column in Oracle","og_description":"Learn how to merge multiple rows into one column in Oracle using LISTAGG function with step-by-step examples.","og_url":"https:\/\/www.silicloud.com\/blog\/how-can-multiple-rows-be-merged-into-one-column-in-oracle\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T07:10:22+00:00","article_modified_time":"2025-08-02T21:31:11+00:00","author":"Noah Thompson","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Noah Thompson","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-can-multiple-rows-be-merged-into-one-column-in-oracle\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-multiple-rows-be-merged-into-one-column-in-oracle\/"},"author":{"name":"Noah Thompson","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/2e83cc6ab9f60d36921c2d0f9f280f4a"},"headline":"Merge Multiple Rows into One Column in Oracle","datePublished":"2024-03-14T07:10:22+00:00","dateModified":"2025-08-02T21:31:11+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-multiple-rows-be-merged-into-one-column-in-oracle\/"},"wordCount":83,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["database tutorial","LISTAGG","Merge Rows","Oracle SQL","SQL Aggregation"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-can-multiple-rows-be-merged-into-one-column-in-oracle\/","url":"https:\/\/www.silicloud.com\/blog\/how-can-multiple-rows-be-merged-into-one-column-in-oracle\/","name":"Merge Multiple Rows into One Column in Oracle - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T07:10:22+00:00","dateModified":"2025-08-02T21:31:11+00:00","description":"Learn how to merge multiple rows into one column in Oracle using LISTAGG function with step-by-step examples.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-multiple-rows-be-merged-into-one-column-in-oracle\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-can-multiple-rows-be-merged-into-one-column-in-oracle\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-can-multiple-rows-be-merged-into-one-column-in-oracle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Merge Multiple Rows into One Column in Oracle"}]},{"@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\/2e83cc6ab9f60d36921c2d0f9f280f4a","name":"Noah Thompson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g","caption":"Noah Thompson"},"url":"https:\/\/www.silicloud.com\/blog\/author\/noahthompson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/7846","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\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=7846"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/7846\/revisions"}],"predecessor-version":[{"id":152640,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/7846\/revisions\/152640"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=7846"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=7846"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=7846"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}