Re: SQLplus help please

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

>>>sql plus version is SQL*Plus: Release 8.0.6.0.0
>>>regards
>>>
>>>MK
>>>
>>>
>>>
>>>
>>>
>>

[Quoted] sqlplus -s $user/$pass_at_inst <<EOF
--------^^

HTH & YMMV HAND! Received on Fri Jun 20 2003 - 14:49:08 CEST