Re: SQLplus help please

[Quoted] Try "set echo off" at the beginning of sqlplus session. Abhijith.

Macius The Great wrote:
> hi!
>
> 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

  here --> set echo off
> 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 ?
> sql plus version is SQL*Plus: Release 8.0.6.0.0
> regards
>
> MK
>
>
>
>
>
Received on Fri Jun 20 2003 - 13:40:04 CEST