Shell Programming and Scripting

SQL>   @scrambler_SELECT_UPDATE_V0.4.sql
 93    EOF
  94   

#!/bin/sh
 #
 # some text

 
  cd <some dir> 

 
  export  ORACLE_HOME
 
  X= 'sqlplus -r u/p@sid <<selectupdate
 spool <some dir>/selectupdateX.txt
    @<script>.sql;
  selectupdate'
 
  #echo $X >  selectupdateX.txt

ORACLE_HOME=/correct/path/to/oracle/stuff
export ORACLE_HOME

cd <wherever>
ORACLE_HOME=/path/to/oracle/stuff/
export ORACLE_HOME

sqlplus -r u/p@sid <<selectupdate
spool <some dir>/selectupdateX.txt
@<script>.sql;
selectupdate

(
sqlplus /nolog <<EOF
conn u/p@$SID
@sql
EOF ) |  tee /path/to/output.txt

#!/bin/sh

ORACLE_HOME=/apps/oracle/10.2.0.4
export ORACLE_HOME
 
sqlplus u/p@sid <<selectupdate
spool selectupdateX.txt
@<script>.sql;
selectupdate

SQL> @<script>.sql;
 93

#!/bin/sh

ORACLE_HOME=/apps/oracle/10.2.0.4
export ORACLE_HOME
 
(
sqlplus /nolog <<EOF
conn TMH7ESD0_TM_ONLINE/TMH7ESD0_TM_ONLINE@TMH3ESD0
@scrambler_SELECT_UPDATE_V0.4.sql;
EOF
) tee selectupdateX.txt

-bash: <scriptname>.sh: line 11: syntax error near unexpected token `tee'
-bash: <scriptname>.sh: line 11: `) tee selectupdateX.txt'

sqlplus u/p@sid <<selectupdate
spool selectupdateX.txt
select id from <table>;
selectupdate

sqlplus u/p@sid <<selectupdate
 spool selectupdateX.txt
 select case when ... blah blah end from <table> where <something>;
 selectupdate

(
sqlplus /nolog <<EOF
conn user/pass@$ORACLE_SID
@test.sql
EOF
) | grep '^update' | tee out.sql

test.sql :
select 'update table set value=''1'' where value2=''2'';' from dual;
select 'update table set value=''5'' where value2=''7'';' from dual;
out.sql :
update table set value='1' where value2='2';
update table set value='5' where value2='7';