try sqlplus -s
--- OraCop <[EMAIL PROTECTED]> wrote: > This is what i am doing: > > 1- login to sqlplus on solaris > 2- spool temp.out > 3- run an sql file useing: @myfile.sql > Sql file contains this: > set termout off > set head off > set echo off > set feedback off > select * from dual; > set termout on > set head on > set echo on > set feedback on > 4- spool off > Spool file has expected output, which is result of > sql statement ONLY! > > Now when i place following in a shell script and run > it > ____________________________ > #!/bin/ksh > > $ORACLE_HOME/bin/sqlplus liserv/liserv@webny << EOF > set feedback off > set head off > set echo off > set termout off > spool output.txt > select * from dual; > spool off > set feedback on > set head on > set echo on > set termout on > exit; > _______________________________ > > Now question is that in later case where i use shell > script along with out put of query , WHY DO I SEE THE > ACTUAL SQL STATEMENT IN SPOOL FILE ALSO? Even though i > have feedback, echo and termout off . > > Any way around. > > I want ONLY output of query in spool file when sql > file is run using a SHELL SCRIPT!. > > Thanks. > > > > > > > > __________________________________________________ > Do you Yahoo!? > Yahoo! Mail Plus - Powerful. Affordable. Sign up now. > http://mailplus.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: OraCop > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
