Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> AW: How to run sql*plus and its command in Windows as batch job?

AW: How to run sql*plus and its command in Windows as batch job?

From: Kulev, Milen <Milen.Kulev_at_BusinessMart.de>
Date: Thu, 20 Mar 2003 11:16:19 +0100
Message-Id: <24726.322519@fatcity.com>


Install Cygwun (http://www.cygwin.com/). Then there wouldn't be a need for format change and you could use (almost)all your UNIX scripts .

Best Regards
MILEN -----Ursprüngliche Nachricht-----
Von: Chuan Zhang [mailto:Chuan.Zhang_at_transact.com.au] Gesendet: Donnerstag, 20. März 2003 04:19 An: Multiple recipients of list ORACLE-L Betreff: How to run sql*plus and its command in Windows as batch job?

Hi, All,

  In unix, we can put following commands in a file and run that file. For example:

$ORACLE_HOME/bin/sqlplus /nolog << EOF
connect test/test
alter sesion set sql_trace=true
select count(*) from product_temp p, invoice_temp i where p.invpsid=i.invoiceid;
disconnect
exit
EOF What's the corresponding format on windows?

Your input is precious,

TIA Chuan
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Chuan Zhang
  INET: Chuan.Zhang_at_transact.com.au

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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 20 2003 - 04:16:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US