If you really want the last line, maybe sysdate was just for kicks, you
could spool
a file before the select, spool off after it, then do a tail -1 on the spool
file
followed by cleaning it up OR leave it around (i.e. remove the file at the
start,
rather than at the end) until the next run just in case you
have problems you can always go back to see what was there the last time it
was run.

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

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).
--

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).
--

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).

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).
Received on Wed Jul 24 2002 - 09:53:33 CDT