{"id":10862,"date":"2024-03-14T12:54:09","date_gmt":"2024-03-14T12:54:09","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-format-line-breaks-when-exporting-data-from-oracle-spool\/"},"modified":"2025-08-04T04:50:14","modified_gmt":"2025-08-04T04:50:14","slug":"how-to-format-line-breaks-when-exporting-data-from-oracle-spool","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-format-line-breaks-when-exporting-data-from-oracle-spool\/","title":{"rendered":"Oracle Spool: Format Line Breaks in Export"},"content":{"rendered":"

When using the spool command in Oracle to export data, by default, the data will not be printed with new lines and will instead be continuously output in the same line. To have each row of data displayed on a new line, you can add the set markup command after the spool command and set the delimiter parameter to ”. The specific steps are as follows:<\/p>\n

    \n
  1. Export data to a file using the spool command, for example:<\/li>\n<\/ol>\n
    spool data.txt\r\nselect * from table_name;\r\nspool off;\r\n<\/code><\/pre>\n
      \n
    1. I will just go ahead and do it by myself.<\/li>\n<\/ol>\n
      spool data.txt\r\nset markup html on delimiter '<br>'\r\nselect * from table_name;\r\nspool off;\r\n<\/code><\/pre>\n
      The data exported in this way will be output in HTML format with each line of data displayed on a new line.<\/p>\n","protected":false},"excerpt":{"rendered":"
      When using the spool command in Oracle to export data, by default, the data will not be printed with new lines and will instead be continuously output in the same line. To have each row of data displayed on a new line, you can add the set markup command after the spool command and set […]<\/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":[1088,3932,8495,13744,3931],"class_list":["post-10862","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-data-export","tag-line-breaks","tag-oracle-spool","tag-set-markup","tag-sql-formatting"],"yoast_head":"\nOracle Spool: Format Line Breaks in Export - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn how to fix line breaks in Oracle spool exports using set markup for cleaner data formatting.\" \/>\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-format-line-breaks-when-exporting-data-from-oracle-spool\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Spool: Format Line Breaks in Export\" \/>\n<meta property=\"og:description\" content=\"Learn how to fix line breaks in Oracle spool exports using set markup for cleaner data formatting.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-format-line-breaks-when-exporting-data-from-oracle-spool\/\" \/>\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-14T12:54:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-04T04:50:14+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-to-format-line-breaks-when-exporting-data-from-oracle-spool\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-format-line-breaks-when-exporting-data-from-oracle-spool\/\"},\"author\":{\"name\":\"Liam\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/23786905eb7b377f45ddb01c17da7671\"},\"headline\":\"Oracle Spool: Format Line Breaks in Export\",\"datePublished\":\"2024-03-14T12:54:09+00:00\",\"dateModified\":\"2025-08-04T04:50:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-format-line-breaks-when-exporting-data-from-oracle-spool\/\"},\"wordCount\":115,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"data export\",\"Line Breaks\",\"Oracle spool\",\"set markup\",\"SQL formatting\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-format-line-breaks-when-exporting-data-from-oracle-spool\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-format-line-breaks-when-exporting-data-from-oracle-spool\/\",\"name\":\"Oracle Spool: Format Line Breaks in Export - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T12:54:09+00:00\",\"dateModified\":\"2025-08-04T04:50:14+00:00\",\"description\":\"Learn how to fix line breaks in Oracle spool exports using set markup for cleaner data formatting.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-format-line-breaks-when-exporting-data-from-oracle-spool\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-format-line-breaks-when-exporting-data-from-oracle-spool\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-format-line-breaks-when-exporting-data-from-oracle-spool\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Spool: Format Line Breaks in Export\"}]},{\"@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":"Oracle Spool: Format Line Breaks in Export - Blog - Silicon Cloud","description":"Learn how to fix line breaks in Oracle spool exports using set markup for cleaner data formatting.","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-format-line-breaks-when-exporting-data-from-oracle-spool\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Spool: Format Line Breaks in Export","og_description":"Learn how to fix line breaks in Oracle spool exports using set markup for cleaner data formatting.","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-format-line-breaks-when-exporting-data-from-oracle-spool\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T12:54:09+00:00","article_modified_time":"2025-08-04T04:50:14+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-to-format-line-breaks-when-exporting-data-from-oracle-spool\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-format-line-breaks-when-exporting-data-from-oracle-spool\/"},"author":{"name":"Liam","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/23786905eb7b377f45ddb01c17da7671"},"headline":"Oracle Spool: Format Line Breaks in Export","datePublished":"2024-03-14T12:54:09+00:00","dateModified":"2025-08-04T04:50:14+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-format-line-breaks-when-exporting-data-from-oracle-spool\/"},"wordCount":115,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["data export","Line Breaks","Oracle spool","set markup","SQL formatting"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-format-line-breaks-when-exporting-data-from-oracle-spool\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-format-line-breaks-when-exporting-data-from-oracle-spool\/","name":"Oracle Spool: Format Line Breaks in Export - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T12:54:09+00:00","dateModified":"2025-08-04T04:50:14+00:00","description":"Learn how to fix line breaks in Oracle spool exports using set markup for cleaner data formatting.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-format-line-breaks-when-exporting-data-from-oracle-spool\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-format-line-breaks-when-exporting-data-from-oracle-spool\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-format-line-breaks-when-exporting-data-from-oracle-spool\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle Spool: Format Line Breaks in Export"}]},{"@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\/10862","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=10862"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/10862\/revisions"}],"predecessor-version":[{"id":154628,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/10862\/revisions\/154628"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=10862"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=10862"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=10862"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}