From: "Jerra" <jerra@aland.net>
Subject: SQLPLUS, scripting problem
Date: 2000/07/07
Message-ID: <8k4ro5$rk2$1@gandalf.alcom.aland.fi>#1/1
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
X-Complaints-To: newsmaster@alcom.aland.fi
X-Trace: gandalf.alcom.aland.fi 962982469 28290 194.112.4.3 (7 Jul 2000 15:07:49 GMT)
Organization: ALCOM
NNTP-Posting-Date: 7 Jul 2000 15:07:49 GMT
Newsgroups: comp.databases.oracle.misc


Hi,

I'm trying to make something similar to a report.

First of all, how do I make SQLPLUS to run the script only once, it runs
forever and ever prompting for new values after each run? CTRL+C only works.

Second thing how do I turn of the feedback showing what variables has been
changed?
old    22:    '&startdate'
new    22:    '01-01-2000'


Is this all in the Oracle docs?

TIA!

/Jerra