Variables with ampersand

[isaboba]

Hi:
I have a sql script, with some variables with "&", for example:
p_tabla_id number(2):=&;

p_nombre varchar2(30):=&; ....

Can I do hidden a variable, depending of an previous variable? For example, can I hidden the variable "p_nombre" depending the value of "p_tabla"
Thanks in advance,
Isa

 

[Marco Kalter]

No, the variable is either hidden or not, and cannot depend on other variables.

 

[isaboba]

Ok. that was I believed.
Thanks,
Isabel