Search notes:

SQL*Plus: SET DEFINE

set define sets the character that indicates substitution variables by prefixing them with this character
set define !

define var=42
define tab=dual

select !var num from !tab;
Variable substitution can be turned of with
set define off
The default character is the ampersand (&).

See also

Using define to assign a value to a variable.
Substitution variables
set escape
SQL*Plus

Index