"Post, Ethan" wrote:
>
> Anyone got an example for the following...
>
> I have a SQL Script that expects &1 passed into it, however, if &1 is not
> supplied I would like to use a default value and not stop to prompt the
> user. I am playing around with new_value and select nvl('&1','foo') from
> dual...etc...and nothing seems to be working.
>
> Thanks,
> Ethan Post
That's the conclusion I have reached myself in the past. Perhaps you can
transform this into a procedure call? Or wrap it into a shell script?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroult
INET: sfaroult_at_oriole.com
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 Fri Oct 18 2002 - 17:13:23 CDT
