Can anyone please explain the use of a double ampersand &&.
Can you please decode the following example and explain the use of && :
WHILE v_price < &&p_count LOOP
v_amount := v_amount + 1;
v_prive := v_amount * &&pct_increase;
you use a double ampersand (&&) if you want to REUSE the variable value without prompting the user to input the value each time.
so, if you have '&&salary' and you put '50000', then in your script you can keep using '&&salary' and it will continue to use the '50000' that was entered at the beginning.
looks like you have '&&' below for some type of table or tablespace creation script or something like that ...
hope that helps.
Thanks for your prompt reply magnus
Click Here to Expand Forum to Full Width