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

Home -> Community -> Usenet -> c.d.o.server -> Parameter passing from SQLPLUS to NT Batch

Parameter passing from SQLPLUS to NT Batch

From: TC3 Racer <gordonchapman_at_hotmail.com>
Date: Mon, 15 Apr 2002 22:03:57 +0100
Message-ID: <diHu8.13729$51.467974@wards>


I want to use an NT batch file, running every hour, to do a

Select count(*) from tablename.

I then want to pass the result out and if its zero, have another batch file that does various things

How do I get the the value out of the sql script

Thanks in advance

GC Received on Mon Apr 15 2002 - 16:03:57 CDT

Original text of this message

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