How do I ignore ampersands in a SQL script running from SQL Plus?

Question

I have a SQL script that creates a package with a comment containing an ampersand (&). When I run the script from SQL Plus, I am prompted to enter a substitute value for the string starting with &. How do I disable this feature so that SQL Plus ignores the ampersand?

Answer 1

The below code will work:

set define off

Otherwise, you should use ampersand at the end of a string,

'StackOverflow &' || ' you'