use a & as a string not for a substitution variable

I want to concantenate a string that includes an & but
I don't want SQLPLUS to prompt me for a variable.

ie; select 'This is a test &' || name from table

SET DEFINE OFF;

...will turn that off for you, then

SET DEFINE ON;

...to turn it back on after the insert (if you actually want it on :) )

- Chris

Thanks works good.

That is not a problem at all, just go ahead and include "&" within single quotes.

Take care