{"id":264,"date":"2013-04-12T13:45:22","date_gmt":"2013-04-12T11:45:22","guid":{"rendered":"http:\/\/www.ict-oke.com\/?p=264"},"modified":"2013-04-12T15:00:48","modified_gmt":"2013-04-12T13:00:48","slug":"email-sql-plus-output-as-csv-from-linux","status":"publish","type":"post","link":"https:\/\/ict-oke.com\/?p=264","title":{"rendered":"Email sql-plus output as csv from Linux"},"content":{"rendered":"

This script can be used for sending sql output via email in CSV format as attachment.<\/p>\n

#!\/bin\/ksh
\n# ————————————————————————-
\n# Script Name :
\n# Author : Hans Schoonen
\n# Version : 1.0
\n# ————————————————————————-<\/p>\n

SetEnv()
\n{
\nNLS_LANG=American_America.UTF8 ; export NLS_LANG
\nORACLE_HOME=[YOUR ORACLE HOME DIR] ; export ORACLE_HOME
\nBinDir=$ORACLE_HOME\/bin ; export BinDir
\n}<\/p>\n

GetData()
\n{
\nrm \/usr\/test\/test.csv
\ntouch \/usr\/test\/test.csv
\n$BinDir\/sqlplus -s apps\/$pswd <<EOF
\nspool \/usr\/test\/test.csv;
\nset serveroutput on size 1000000;
\nset verify off;
\nset wrap on;
\nset colsep ,;
\nset pagesize 1000;
\nset trimspool on;
\nset headsep off;
\nset linesize 9999;
\n@\/usr\/test\/test.sql;
\nspool off;
\nexit
\nEOF<\/p>\n

}<\/p>\n

MaillData()
\n{
\ncat \/usr\/test\/test.csv | uuencode test.csv | mail -s “Report ICT-OKE Data” info@ict-oke.com
\n}<\/p>\n

SetEnv<\/p>\n

GetData<\/p>\n

MailData<\/p>\n

exit
\n <\/p>\n","protected":false},"excerpt":{"rendered":"

This script can be used for sending sql output via email in CSV format as attachment. #!\/bin\/ksh # ————————————————————————- # Script Name : # Author : Hans Schoonen # Version : 1.0 # ————————————————————————- SetEnv() { NLS_LANG=American_America.UTF8 ; export NLS_LANG ORACLE_HOME=[YOUR ORACLE HOME DIR] ; export ORACLE_HOME BinDir=$ORACLE_HOME\/bin ; export BinDir } GetData() { rm […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"_links":{"self":[{"href":"https:\/\/ict-oke.com\/index.php?rest_route=\/wp\/v2\/posts\/264"}],"collection":[{"href":"https:\/\/ict-oke.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ict-oke.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"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=264"}],"version-history":[{"count":6,"href":"https:\/\/ict-oke.com\/index.php?rest_route=\/wp\/v2\/posts\/264\/revisions"}],"predecessor-version":[{"id":278,"href":"https:\/\/ict-oke.com\/index.php?rest_route=\/wp\/v2\/posts\/264\/revisions\/278"}],"wp:attachment":[{"href":"https:\/\/ict-oke.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=264"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ict-oke.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=264"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ict-oke.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=264"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}