OR

# !/bin/ksh
# set -x
sqlplus / <<EOF  | tail -1
select sysdate from dual;
exit
EOF


Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
"The problem with some people is that when they aren't drunk, they're sober."  
--William Butler
Yeats.


                                                                                       
                            
                      [EMAIL PROTECTED]                                                
                            
                      om                       To:       [EMAIL PROTECTED]          
                            
                      Sent by:                 cc:                                     
                            
                      [EMAIL PROTECTED]         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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Reply via email to