Re: SQLplus help please

[Quoted] yes echo is off but in the data file there is no suspected column header na this _at_!#$@!#$@! sql :( code. How to turn heading on and turn off sql code output to file.

set appinfo ON
set appinfo "SQL*Plus"
set arraysize 15
set autocommit OFF
set autoprint OFF
set autotrace OFF
set blockterminator "."
set cmdsep OFF
set colsep "|"
set compatibility NATIVE
set concat "|"
set copycommit 0
set copytypecheck ON
set define "&"
set echo OFF
set editfile "afiedt.buf"
set embedded OFF
set escape OFF
set feedback 6
set flagger OFF
set flush ON
set heading ON
set headsep "|"
set linesize 120
set long 120
set longchunksize 80
set newpage 0
set null ""
set numformat ""
set numwidth 10
set pagesize 0
set pause OFF
set recsep WRAP
set recsepchar " "
set serveroutput OFF
set shiftinout invisible
set showmode OFF
set sqlcase MIXED
set sqlcontinue "> "
set sqlnumber ON
set sqlprefix "#"
set sqlprompt "SQL> "
set sqlterminator ";"
set suffix "sql"
set tab ON
set termout ON
set time OFF
set timing OFF
set trimout ON
set trimspool OFF
set underline "-"
set verify ON
set wrap ON

Uzytkownik "abhijith" <abhijit_at_nomail.com> napisal w wiadomosci news:3EF2F294.1090408_at_nomail.com...
> 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 - 14:04:34 CEST