RE: Calling SQL statement

From: Conboy, Jim <Jim.Conboy_at_trw.com>
Date: Thu, 14 Mar 2002 06:03:27 -0800
Message-ID: <F001.004290E8.20020314060327@fatcity.com>

There was just the ticket in an Oracle mag online piece by Ian Craig a while back.

http://www.oracle.com/oramag/webcolumns/2001/index.html?op_unixway.html

A trivial example from the article:

---

print "select * from dual;" | sqlplus -s scott/tiger

produces the following output:

D
-
X

---

Jim

-----Original Message-----
Sent: Thursday, March 14, 2002 8:33 AM
To: Multiple recipients of list ORACLE-L

!/bin/ksh
sqlplus / <<EOF
select sysdate from dual;
EOF
exit

>>> waibals_at_mtn.co.ug 03/14/02 06:26AM >>>

Hi all,
How do I issue SQL staments to the Oracle server from shell scripts -preferably korn shell. Example scripts highly welcome.

Thanx 'n Ciao

+---------------------------------------------------+

CSW,
MTN-Uganda, 8th Floor UDB Building
Cell: 077-212655,http://mtn.co.ug

+---------------------------------------------------+ 

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author: Simon Waibale
  INET: waibals_at_mtn.co.ug 

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: Gene Sais
  INET: Gsais_at_co.palm-beach.fl.us

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: Conboy, Jim
  INET: Jim.Conboy_at_trw.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 Thu Mar 14 2002 - 08:03:27 CST