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