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 -> reset variables

reset variables

From: miker <mdent12_at_none.com>
Date: Fri, 22 Feb 2002 21:47:35 GMT
Message-ID: <hled7u4v0sajr5k2ebcbor1ea86c4msomj@4ax.com> 





I run a sql script with &&1 for several variables, i.e all 9 instances
of this variable get the same value.  How do I get the script to
prompt for new value only once when it is rerun in the same sql
session?  If I use &1 then it prompts me 9 times, once for each time
this variable is used.
Received on Fri Feb 22 2002 - 15:47:35 CST












Original text of this message













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