Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Easy SQL*Plus question (I think)
Hi Anne,
Anne Hanson wrote:
>
> Is there a simple way to set up the following SQL statement so I'm not
> prompted 3 times for the &chaintab substitution variable?
I think that if you double the '&' for any than the first occurence of the formal parameter, you will not be asked again. Also there is a command like SET VERIFY OFF that may be necessary at front.
cheers,
Michael
Received on Thu Oct 14 1999 - 13:45:43 CDT