René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

set escape [SQL*Plus]

set escape c
Sets the escape characters (used for defined variables to c. c must be one single character. The default is the ampersand (&).
set escape *
set verify off

define somevar="bla bla bla"

select '&somevar' a, 
       '*somevar' b
from dual;
'SOMEVA
-------
somevar
A           B
----------- -------
bla bla bla somevar