SQLplus help please

From: Macius The Great <"Macius>
Date: Fri, 20 Jun 2003 13:31:44 +0200
Message-ID: <bcurbg$eco$1_at_nemesis.news.tpi.pl>

hi!

[Quoted] I use sh script for data dump from oracle to file. The script goes :

#!/usr/bin/sh
bla bla ...

while (( i < ${#oper[*]} ))
do
sqlplus $user/$pass_at_inst <<EOF

[Quoted] spool /some/directory/${oper[i]}_$full_data.txt select
...

from
...

where
...

order
...;

spool off;
EOF
((i=i+1))
done

its siple !

but the output is :
$cat data.txt

SQL> select
SQL> ...
SQL> from
SQL> ...
SQL> where
SQL> ...
SQL> order by ...;

data 1
data 2
...

data n
SQL> spool off;
$

how to set SQLPLUS environment for not include SQL statment in spool file ? [Quoted] sql plus version is SQL*Plus: Release 8.0.6.0.0 regards

MK Received on Fri Jun 20 2003 - 13:31:44 CEST