{"id":13997,"date":"2020-01-20T15:56:46","date_gmt":"2020-01-20T15:56:46","guid":{"rendered":"https:\/\/dbtut.com\/?p=13997"},"modified":"2020-01-20T15:56:48","modified_gmt":"2020-01-20T15:56:48","slug":"how-to-export-data-from-sql-plus-to-csv","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2020\/01\/20\/how-to-export-data-from-sql-plus-to-csv\/","title":{"rendered":"How To Export Data From SQL Plus to CSV"},"content":{"rendered":"<p>With Oracle 12.2.0.1, SQL * Plus is capable of displaying the result of a query as CSV.<\/p>\n<p>Its use is as follows.<\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; SET MARK[UP] CSV {ON|OFF} DELIMI[TER] character QUOTE {ON|OFF}<\/pre>\n<h2>Options<\/h2>\n<p><strong>DELIMI[TER] :<\/strong> The character used to separate column values. Only single characters are allowed. The default value is \u201c,\u201d (comma).<\/p>\n<p><strong>QUOTE :<\/strong> If this is ON, the column values that are text are shown in \u201c\u201d (double quotation marks). It can take ON or OFF values. The default value is OFF.<\/p>\n<h3>Generate CSV output in double quotes<\/h3>\n<pre class=\"lang:default decode:true\">SQL&gt; SET MARKUP CSV ON QUOTE ON\nSQL&gt; SELECT * FROM PERSON;\n\n\"ID\",\"NAME\",\"SURNAME\"\n1,\"AHMET\",\"DURUOZ\"\n2,\"ALI\",\"VELI\"\n3,\"VELI\",\"ALI\"<\/pre>\n<h3>Generate CSV output without double quotes<\/h3>\n<pre class=\"lang:default decode:true\">SQL&gt; SET MARKUP CSV ON QUOTE OFF\nSQL&gt; SELECT * FROM PERSON;\n\nID,NAME,SURNAME\n1,AHMET,DURUOZ\n2,ALI,VELI\n3,VELI,ALI<\/pre>\n<h3>Generate CSV output using &#8220;| (pipe)&#8221; as delimiter<\/h3>\n<pre class=\"lang:default decode:true\">SQL&gt; SET MARKUP CSV ON DELIMITER |\nSQL&gt; SELECT * FROM PERSON;\n\nID|NAME|SURNAME\n1|AHMET|DURUOZ\n2|ALI|VELI\n3|VELI|ALI<\/pre>\n<p>By using the -M parameter from the command line as follows, the output can be created in csv format by running the script.<\/p>\n<pre class=\"lang:default decode:true\">[oracle@orcldb ~]$ sqlplus -S -M \"csv on\" \/ as sysdba @\/home\/oracle\/person.sql | sed '\/^$\/d'\n\"ID\",\"NAME\",\"SURNAME\"\n1,\"AHMET\",\"DURUOZ\"\n2,\"ALI\",\"VELI\"\n3,\"VELI\",\"ALI\"<\/pre>\n<p>With the command &#8220;sed &#8216;\/^$\/d'&#8221;, we ensure that the space that appears at the beginning and end of the output is not displayed. Otherwise, it will be displayed with spaces as follows.<\/p>\n<pre class=\"lang:default decode:true\">[oracle@orcldb ~]$ sqlplus -S -M \"csv on\" \/ as sysdba @\/home\/oracle\/person.sql\n\n\"ID\",\"NAME\",\"SURNAME\"\n1,\"AHMET\",\"DURUOZ\"\n2,\"ALI\",\"VELI\"\n3,\"VELI\",\"ALI\"\n\n[oracle@orcldb ~]$<\/pre>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_13997\" class=\"pvc_stats all  \" data-element-id=\"13997\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>With Oracle 12.2.0.1, SQL * Plus is capable of displaying the result of a query as CSV. Its use is as follows. SQL&gt; SET MARK[UP] CSV {ON|OFF} DELIMI[TER] character QUOTE {ON|OFF} Options DELIMI[TER] : The character used to separate column values. Only single characters are allowed. The default value is \u201c,\u201d (comma). QUOTE : If &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_13997\" class=\"pvc_stats all  \" data-element-id=\"13997\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":13998,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[6226,6216,6218,6217,6230,6231,6233,6234,6232,6219,6220,6215,6213,6208,6203,6205,6207,6204,6236,6228,6227,6229,6221,6222,6224,6225,6235,6223,6210,6209,6211,6214,6206,6212,6201,6200,6202],"class_list":["post-13997","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-export-data-from-sqlplus-to-csv","tag-export-sql-results-to-excel-using-sqlplus","tag-formatting-query-results-to-csv-in-sql-plus","tag-formatting-query-results-to-csv-in-sqlplus","tag-generate-csv-output-in-double-quotes","tag-generate-csv-output-in-double-quotes-in-sql-plus","tag-generate-csv-output-using-pipe-as-delimiter","tag-generate-csv-output-using-as-delimiter","tag-generate-csv-output-without-double-quotes","tag-generate-csv-with-sql-plus","tag-generate-csv-with-sqlplus","tag-how-do-i-export-data-from-sqlplus","tag-how-to-write-to-a-csv-file-using-sqlplus","tag-sql-plus-csv-file","tag-sql-plus-export-to-csv3","tag-sql-plus-output-to-csv","tag-sql-plus-output-to-csv-file","tag-sql-plus-spool-to-csv","tag-sql-to-csv-trim","tag-sqlplus-export-csv","tag-sqlplus-export-to-csv","tag-sqlplus-output-csv","tag-sqlplus-csv","tag-sqlplus-csv-export","tag-sqlplus-csv-format","tag-sqlplus-csv-format-output","tag-sqlplus-csv-format-trim","tag-sqlplus-csv-output","tag-sqlplus-export-csv-format","tag-sqlplus-export-to-csv-with-column-names","tag-sqlplus-output-csv-format","tag-sqlplus-query-output-to-csv","tag-sqlplus-query-to-csv","tag-sqlplus-spool-csv-format","tag-sqlplus-to-csv","tag-sqlplus-to-csv-export","tag-sqlplus-to-csv-with-header"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Export Data From SQL Plus to CSV - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Export Data From SQL Plus to CSV\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2020\/01\/20\/how-to-export-data-from-sql-plus-to-csv\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Export Data From SQL Plus to CSV - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Export Data From SQL Plus to CSV\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2020\/01\/20\/how-to-export-data-from-sql-plus-to-csv\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2020-01-20T15:56:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-01-20T15:56:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-77.png\" \/>\n\t<meta property=\"og:image:width\" content=\"507\" \/>\n\t<meta property=\"og:image:height\" content=\"268\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\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:\/\/dbtut.com\/index.php\/2020\/01\/20\/how-to-export-data-from-sql-plus-to-csv\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/20\/how-to-export-data-from-sql-plus-to-csv\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Export Data From SQL Plus to CSV\",\"datePublished\":\"2020-01-20T15:56:46+00:00\",\"dateModified\":\"2020-01-20T15:56:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/20\/how-to-export-data-from-sql-plus-to-csv\/\"},\"wordCount\":156,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/20\/how-to-export-data-from-sql-plus-to-csv\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-77.png\",\"keywords\":[\"Export Data From SQL*Plus to CSV\",\"Export SQL Results To Excel Using SQLPLUS\",\"Formatting Query Results to CSV in sql plus\",\"Formatting Query Results to CSV in sqlplus\",\"Generate CSV output in double quotes\",\"Generate CSV output in double quotes in sql plus\",\"Generate CSV output using \\\"| (pipe)\\\" as delimiter\",\"Generate CSV output using \\\"|\\\" as delimiter\",\"Generate CSV output without double quotes\",\"Generate CSV with SQL Plus\",\"Generate CSV with SQLPlus\",\"How do I export data from Sqlplus?\",\"How to Write to a CSV File Using sqlplus\",\"sql plus csv file\",\"sql plus export to csv3\",\"sql plus output to csv\",\"sql plus output to csv file\",\"sql plus spool to csv\",\"sql to csv trim\",\"SQL*Plus export csv\",\"SQL*Plus export to csv\",\"SQL*Plus output csv\",\"sqlplus csv\",\"sqlplus csv export\",\"sqlplus csv format\",\"sqlplus csv format output\",\"sqlplus csv format trim\",\"sqlplus csv output\",\"sqlplus export csv format\",\"sqlplus export to csv with column names\",\"sqlplus output csv format\",\"SQLPLUS query output to csv\",\"sqlplus query to csv\",\"sqlplus spool csv format\",\"sqlplus to csv\",\"sqlplus to csv export\",\"sqlplus to csv with header\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/01\/20\/how-to-export-data-from-sql-plus-to-csv\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/20\/how-to-export-data-from-sql-plus-to-csv\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/20\/how-to-export-data-from-sql-plus-to-csv\/\",\"name\":\"How To Export Data From SQL Plus to CSV - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/20\/how-to-export-data-from-sql-plus-to-csv\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/20\/how-to-export-data-from-sql-plus-to-csv\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-77.png\",\"datePublished\":\"2020-01-20T15:56:46+00:00\",\"dateModified\":\"2020-01-20T15:56:48+00:00\",\"description\":\"How To Export Data From SQL Plus to CSV\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/20\/how-to-export-data-from-sql-plus-to-csv\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/01\/20\/how-to-export-data-from-sql-plus-to-csv\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/20\/how-to-export-data-from-sql-plus-to-csv\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-77.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-77.png\",\"width\":507,\"height\":268},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/20\/how-to-export-data-from-sql-plus-to-csv\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Export Data From SQL Plus to CSV\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Export Data From SQL Plus to CSV - Database Tutorials","description":"How To Export Data From SQL Plus to CSV","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:\/\/dbtut.com\/index.php\/2020\/01\/20\/how-to-export-data-from-sql-plus-to-csv\/","og_locale":"en_US","og_type":"article","og_title":"How To Export Data From SQL Plus to CSV - Database Tutorials","og_description":"How To Export Data From SQL Plus to CSV","og_url":"https:\/\/dbtut.com\/index.php\/2020\/01\/20\/how-to-export-data-from-sql-plus-to-csv\/","og_site_name":"Database Tutorials","article_published_time":"2020-01-20T15:56:46+00:00","article_modified_time":"2020-01-20T15:56:48+00:00","og_image":[{"width":507,"height":268,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-77.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/20\/how-to-export-data-from-sql-plus-to-csv\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/20\/how-to-export-data-from-sql-plus-to-csv\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Export Data From SQL Plus to CSV","datePublished":"2020-01-20T15:56:46+00:00","dateModified":"2020-01-20T15:56:48+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/20\/how-to-export-data-from-sql-plus-to-csv\/"},"wordCount":156,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/20\/how-to-export-data-from-sql-plus-to-csv\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-77.png","keywords":["Export Data From SQL*Plus to CSV","Export SQL Results To Excel Using SQLPLUS","Formatting Query Results to CSV in sql plus","Formatting Query Results to CSV in sqlplus","Generate CSV output in double quotes","Generate CSV output in double quotes in sql plus","Generate CSV output using \"| (pipe)\" as delimiter","Generate CSV output using \"|\" as delimiter","Generate CSV output without double quotes","Generate CSV with SQL Plus","Generate CSV with SQLPlus","How do I export data from Sqlplus?","How to Write to a CSV File Using sqlplus","sql plus csv file","sql plus export to csv3","sql plus output to csv","sql plus output to csv file","sql plus spool to csv","sql to csv trim","SQL*Plus export csv","SQL*Plus export to csv","SQL*Plus output csv","sqlplus csv","sqlplus csv export","sqlplus csv format","sqlplus csv format output","sqlplus csv format trim","sqlplus csv output","sqlplus export csv format","sqlplus export to csv with column names","sqlplus output csv format","SQLPLUS query output to csv","sqlplus query to csv","sqlplus spool csv format","sqlplus to csv","sqlplus to csv export","sqlplus to csv with header"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2020\/01\/20\/how-to-export-data-from-sql-plus-to-csv\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/20\/how-to-export-data-from-sql-plus-to-csv\/","url":"https:\/\/dbtut.com\/index.php\/2020\/01\/20\/how-to-export-data-from-sql-plus-to-csv\/","name":"How To Export Data From SQL Plus to CSV - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/20\/how-to-export-data-from-sql-plus-to-csv\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/20\/how-to-export-data-from-sql-plus-to-csv\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-77.png","datePublished":"2020-01-20T15:56:46+00:00","dateModified":"2020-01-20T15:56:48+00:00","description":"How To Export Data From SQL Plus to CSV","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/20\/how-to-export-data-from-sql-plus-to-csv\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2020\/01\/20\/how-to-export-data-from-sql-plus-to-csv\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/20\/how-to-export-data-from-sql-plus-to-csv\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-77.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-77.png","width":507,"height":268},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/20\/how-to-export-data-from-sql-plus-to-csv\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Export Data From SQL Plus to CSV"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/13997","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=13997"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/13997\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/13998"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=13997"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=13997"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=13997"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}