Shell Programming and Scripting

sqlplus username/pass@SID @script.sql

sqlplus username/pass@sid

rm /tmp/blah.txt



sqlplus  user/pass@SID

spool /tmp/blah.txt
SELECT
  ta.foo
  ,cn.bar
  , count(*) cnt
FROM
  foo_bar ta
  , bar_foo cn
  WHERE
    ta.blah <= sysdate
    and ta.bleep=09
    and ta.foo=cn.foo
Group BY cn.bar,ta.bar
ORDER BY cnt DESC
spool off;

cat /tmp/blah.txt | mailx -s "HERE YOU GO" whoever@wherever.com
chmod 666 /tmp/blah.txt

sqlplus user/pass@SID <<EO_SQL
spool /tmp/blah.txt
SELECT
ta.foo
,cn.bar
, count(*) cnt
FROM
foo_bar ta
, bar_foo cn
WHERE
ta.blah <= sysdate
and ta.bleep=09
and ta.foo=cn.foo
Group BY cn.bar,ta.bar
ORDER BY cnt DESC
;
spool off
-- note the moving of the ";" or GO string...
EO_SQL

sqlplus user/pass@SID @sql_file.sql 
# where sql_file.sql contains the SQL commands, including an exit after spool off...

   set      colsep                              "|" 
   set      feedback                            off 
   set      heading                             on  
   set      pages                               0   
   set      lines                               200 
   set      underline                           off 
   set      verify                              off 
   set      termout                             off 
   set      trimspool                           on