Using substitution variables in Oracle 9i isqlplus

The oracle| variable makes it easy to create a generic pin local purpose by replacing a variable, and look at the following code:
INSERT into Employees (Emp_name, Emp_age, emp_dept) VALUES (' &empname ', &empage, &empdept)
Using the "&" plus identifier to represent the substitution variable, note that if the data type of the column is a character or date type, enclose the substitution variable in single quotes. When executed, Isqlplus asks for three substitution variable values, which can improve productivity if you save this statement as a script.