Case Closed: Unix Q: ksh scripting

Hello all,

Great replies! After reading all your replies I realized where I went wrong. I'm putting my "| tail -1" in the wrong end of the "EOF" marker. Should have been on the first one not the last. This works fine for what I intend to do:
# !/bin/ksh
# set -x
sqlplus / <<EOF | tail -1
select sysdate from dual;
exit
EOF My intention is not really just to get the date. It's really to get the last line of the output. This script is just a simplified version of a more complex shell script I'm working on.
Thanks a lot to all who responded and those who attempted to.

Cheers,
Ross

> -----Original Message-----
> From: Ross Collado
> Sent: Wednesday, 24 July 2002 14:53
> To: Multiple recipients of list ORACLE-L
> Subject: Unix Q: ksh scripting
>
>
> Hi all,
> Can any of our Unix gurus here transform my script below to
> work properly?
> The intention is to print the last line of the sqlplus output.
> With set -x, it appears anything after the last EOF is ignored. Why?
> Thanks.
> Ross
>
> #!/bin/ksh
> #set -x
> sqlplus / <<EOF
> select sysdate from dual;
> exit
> EOF | tail -1
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ross Collado
> INET: Ross.Collado_at_techpac.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ross Collado
  INET: Ross.Collado_at_techpac.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).