{"id":268,"date":"2013-04-12T13:49:48","date_gmt":"2013-04-12T11:49:48","guid":{"rendered":"http:\/\/www.ict-oke.com\/?page_id=268"},"modified":"2013-04-16T09:42:26","modified_gmt":"2013-04-16T07:42:26","slug":"shell-scripts","status":"publish","type":"page","link":"https:\/\/ict-oke.com\/?page_id=268","title":{"rendered":"Shell Scripts"},"content":{"rendered":"<p><a href=\"https:\/\/ict-oke.com\/wp-content\/uploads\/2013\/04\/images.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-269\" alt=\"images\" src=\"https:\/\/ict-oke.com\/wp-content\/uploads\/2013\/04\/images.jpg\" width=\"242\" height=\"181\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Please click the subject for a readable format of the script you want to view.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>\u00a0<\/p>\n<div id=\"post-xx\" class=\"post-xx\"><h2 class=\"entry-title\"><br \/><a rel=\"bookmark\" title=\"Permalink to Email sql-plus output as csv from Linux \" href=\"http:\/\/www.ict-oke.com\/?p=264\">Email sql-plus output as csv from Linux <\/a><\/h2><div class=\"entry-meta\"><span class=\"meta-prep meta-prep-author\">Posted on <\/span><a rel=\"bookmark\" title=\"13:45\" href=\"http:\/\/www.ict-oke.com\/?p=264\"> <span class=\"entry-date\">12. April 2013<\/span><\/a><span class=\"meta-sep\"> by <\/span><span class=\"author vcard\"><a class=\"url fn n\" title=\"View all posts by admin\" href=\"http:\/\/www.ict-oke.com\/?p=264?author=2\">admin<\/a><\/span><\/div><div class=\"entry-content\"><p>This script can be used for sending sql output via email in CSV format as attachment.\r\n\r\n#!\/bin\/ksh\r\n# -------------------------------------------------------------------------\r\n# Script Name :\r\n# Author : Hans Schoonen\r\n# Version : 1.0\r\n# -------------------------------------------------------------------------\r\n\r\nSetEnv()\r\n{\r\nNLS_LANG=American_America.UTF8 ; export NLS_LANG\r\nORACLE_HOME=[YOUR ORACLE HOME DIR] ; export ORACLE_HOME\r\nBinDir=$ORACLE_HOME\/bin ; export BinDir\r\n}\r\n\r\nGetData()\r\n{\r\nrm \/usr\/test\/test.csv\r\ntouch \/usr\/test\/test.csv\r\n$BinDir\/sqlplus -s apps\/$pswd &lt;&lt;EOF\r\nspool \/usr\/test\/test.csv;\r\nset serveroutput on size 1000000;\r\nset verify off;\r\nset wrap on;\r\nset colsep ,;\r\nset pagesize 1000;\r\nset trimspool on;\r\nset headsep off;\r\nset linesize 9999;\r\n@\/usr\/test\/test.sql;\r\nspool off;\r\nexit\r\nEOF\r\n\r\n}\r\n\r\nMaillData()\r\n{\r\ncat \/usr\/test\/test.csv | uuencode test.csv | mail -s \"Report ICT-OKE Data\" info@ict-oke.com\r\n}\r\n\r\nSetEnv\r\n\r\nGetData\r\n\r\nMailData\r\n\r\nexit\r\n&nbsp;<\/p><\/div><div class=\"entry-utility\"><span class=\"comments-link\"><a title=\"Leave a commentEmail sql-plus output as csv from Linux \" href=\"http:\/\/www.ict-oke.com\/?p=264#comments\"> no comments <\/a><\/span><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>&nbsp; Please click the subject for a readable format of the script you want to view. &nbsp; &nbsp; \u00a0 Email sql-plus output as csv from Linux Posted on 12. April 2013 by adminThis script can be used for sending sql output via email in CSV format as attachment. #!\/bin\/ksh # &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;- # Script Name : [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":118,"menu_order":6,"comment_status":"open","ping_status":"open","template":"template-onecolumn.php","meta":{"footnotes":""},"_links":{"self":[{"href":"https:\/\/ict-oke.com\/index.php?rest_route=\/wp\/v2\/pages\/268"}],"collection":[{"href":"https:\/\/ict-oke.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/ict-oke.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/ict-oke.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ict-oke.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=268"}],"version-history":[{"count":9,"href":"https:\/\/ict-oke.com\/index.php?rest_route=\/wp\/v2\/pages\/268\/revisions"}],"predecessor-version":[{"id":283,"href":"https:\/\/ict-oke.com\/index.php?rest_route=\/wp\/v2\/pages\/268\/revisions\/283"}],"up":[{"embeddable":true,"href":"https:\/\/ict-oke.com\/index.php?rest_route=\/wp\/v2\/pages\/118"}],"wp:attachment":[{"href":"https:\/\/ict-oke.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=268"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}