Double Ampersand &&?

Hi Friends,

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;
END LOOP;

Many Thanks

Suresh

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.

- Magnus

Thanks for your prompt reply magnus

Suresh