Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: c-shell: use of << EOF and piping

Re: c-shell: use of << EOF and piping

From: J.A. Gutierrez <spd_at_daphne.cps.unizar.es>
Date: 1998/04/25
Message-ID: <6ht96j$fp3$2@celes.unizar.es>#1/1

In comp.unix.shell Ben Moretti <crung_at_cobweb.com.au> wrote:

: sqlplus << EOF
: username/password
: @select_script.sql $1 $VARIABLE
: EOF | awk '/ORA-/||/PLS-/||/PL\/SQL:/' > select.log
 

: does not work. i suppose i could write it to a temp file or something and
: then cat that for awk, but that's not the point is it?

sqlplus << EOF | awk '/ORA-/||/PLS-/||/PL\/SQL:/' > select.log username/password
@select_script.sql $1 $VARIABLE
EOF         should work

        or
(
sqlplus << EOF
username/password
@select_script.sql $1 $VARIABLE
EOF
)| awk '/ORA-/||/PLS-/||/PL\/SQL:/' > select.log

-- 
PGP and other useless info at      \      Quan on est mort c'est tous
http://www.cps.unizar.es/~spd/      \     les jours dimanche
finger://daphne.cps.unizar.es/spd    \                    Jean Dolent
VISA: 566<Can't write .signature: Disc quota exceeded>
Received on Sat Apr 25 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US