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 -> Re: Easy SQL*Plus question (I think)

Re: Easy SQL*Plus question (I think)

From: Michael Joost <MichaelJoost_at_t-online.de>
Date: Thu, 14 Oct 1999 20:45:43 +0200
Message-ID: <380624D7.A4A96659@t-online.de> 





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












Original text of this message













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