{"id":429,"date":"2017-04-03T14:15:59","date_gmt":"2017-04-03T17:15:59","guid":{"rendered":"http:\/\/gianfratti.com\/?p=429"},"modified":"2017-04-06T17:38:19","modified_gmt":"2017-04-06T20:38:19","slug":"429","status":"publish","type":"post","link":"http:\/\/gianfratti.com\/index.php\/429\/","title":{"rendered":"Oracle &#8211; Gerar arquivo Delimitado"},"content":{"rendered":"<p>Recentemente precisei salvar um arquivo delimitado a partir de uma <strong>Query no Oracle<\/strong> e comecei a fazer umas pesquisas no Google e encontrei algumas solu\u00e7\u00f5es bem \u201c<strong>mirabolantes<\/strong>\u201d, a partir dai comecei a escrever um script que fosse de simples entendimento.<\/p>\n<p>O objetivo do script \u00e9 gerar\u00a0 um arquivo <strong>CSV<\/strong> delimitado por <strong>\u201c,\u201d<\/strong> para depois importa-lo no <strong>Excel.<br \/>\n<\/strong><!--more--><\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\nSET HEADING\u00a0\u00a0\u00a0\u00a0 ON\r\nSET TRIMSPOOL\u00a0\u00a0\u00a0\u00a0 ON\r\nSET TRIMOUT\u00a0\u00a0\u00a0\u00a0 ON\r\nSET WRAP\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OFF\r\nSET TERMOUT\u00a0\u00a0\u00a0\u00a0 OFF\r\nSET PAGES\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3000\r\nSET LINES\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3500\r\nSET COLSEP\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ','\r\nALTER SESSION SET NLS_DATE_FORMAT = 'DD\/MM\/YYYY';\r\nSPOOL C:\\TEMP\\RESULTADO.CSV\r\n\r\nSELECT * FROM ALL_TABLES;\r\n\r\nSPOOL OFF\r\n<\/pre>\n<p>Obs: Ao copiar o script acima alterar as aspas simples, pois o editar do site altera a formata\u00e7\u00e3o \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Recentemente precisei salvar um arquivo delimitado a partir de uma Query no Oracle e comecei a fazer umas pesquisas no Google e encontrei algumas solu\u00e7\u00f5es bem \u201cmirabolantes\u201d, a partir dai comecei a escrever um script que fosse de simples entendimento. <span class=\"ellipsis\">&hellip;<\/span> <span class=\"more-link-wrap\"><a href=\"http:\/\/gianfratti.com\/index.php\/429\/\" class=\"more-link\"><span>Read More &rarr;<\/span><\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[17,82],"tags":[85,86,84,83],"class_list":["post-429","post","type-post","status-publish","format-standard","hentry","category-banco-de-dados","category-oracle","tag-csv","tag-delimitado","tag-excel","tag-oracle"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/gianfratti.com\/index.php\/wp-json\/wp\/v2\/posts\/429","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/gianfratti.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/gianfratti.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/gianfratti.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/gianfratti.com\/index.php\/wp-json\/wp\/v2\/comments?post=429"}],"version-history":[{"count":8,"href":"http:\/\/gianfratti.com\/index.php\/wp-json\/wp\/v2\/posts\/429\/revisions"}],"predecessor-version":[{"id":451,"href":"http:\/\/gianfratti.com\/index.php\/wp-json\/wp\/v2\/posts\/429\/revisions\/451"}],"wp:attachment":[{"href":"http:\/\/gianfratti.com\/index.php\/wp-json\/wp\/v2\/media?parent=429"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/gianfratti.com\/index.php\/wp-json\/wp\/v2\/categories?post=429"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/gianfratti.com\/index.php\/wp-json\/wp\/v2\/tags?post=429"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}