Oracle-L: Re: Unix Q: ksh scripting

From: Ron Thomas <rthomas_at_hypercom.com>
Date: Wed, 24 Jul 2002 09:05:21 -0800
Message-ID: <F001.004A10AF.20020724090521@fatcity.com>

# !/bin/ksh
# set -x
sqlplus / <<EOF | tail -1
select sysdate from dual;
exit
EOF Ron Thomas
Hypercom, Inc
rthomas_at_hypercom.com
"The problem with some people is that when they aren't drunk, they're sober." --William Butler Yeats.

                                                                                                                   
                      lembark_at_wrkhors.c                                                                            
                      om                       To:       ORACLE-L_at_fatcity.com                                      
                      Sent by:                 cc:                                                                 
                      root_at_fatcity.com         Subject:  Re: Unix Q: ksh scripting                                 
                                                                                                                   
                                                                                                                   
                      07/24/02 07:53 AM                                                                            
                      Please respond to                                                                            
                      ORACLE-L                                                                                     
                                                                                                                   
                                                                                                                   





># !/bin/ksh
># set -x

> sqlplus / <<EOF
> select sysdate from dual;
> exit
> EOF | tail -1

The close needs to be on a line by itself:

(

        foo <<- BAR
        stuff here
        BAR

) | tail -1;

will do what you want.

--
Steven Lembark                              2930 W. Palmer
Workhorse Computing                      Chicago, IL 60647
                                           +1 800 762 1582
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: lembark_at_wrkhors.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: Ron Thomas
  INET: rthomas_at_hypercom.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).

Received on Wed Jul 24 2002 - 12:05:21 CDT