What is Substitution Variable in Oracle

Substitution variable is a user variable name preceded by ampersands (&) .

Use of Substitution Variable(&)

Example:

Create table test1 (id number, name varchar2 (50), job varchar2 (50), mobile number);

Insert into test1 values (1,'vinod','gov',9453534145);

Insert into test1 values (2,'ashu','gov',9453534148);

Insert into test1 values (3,'rahul','priv',9453534172);                    

Insert into test1 values (4,'solhu','self',9453539158);

Insert into test1 values (5,'pradep','priv',9456534148);

Insert into test1 values (6,'mishra','gov',9453538148);

Insert into test1 values (7,'pal','self', 9453536448);    

in this example enter id at run time .

if set verify off   then old & new not show 

In above example two variable is used table_name and enter_id