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

sql oracle sqlplus
JoshL picture JoshL · Sep 23, 2008 · Viewed 177.4k times · Source

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

Austin Salonen picture Austin Salonen · Sep 23, 2008

This may work for you:

set define off

Otherwise the ampersand needs to be at the end of a string, 

'StackOverflow &' || ' you'

EDIT: I was click-happy when saving... This was referenced from a blog.

Related questions

How do I spool to a CSV formatted file using SQLPLUS?

I want to extract some queries to a CSV output format. Unfortunately, I can't use any fancy SQL client or any language to do it. I must use SQLPLUS. How do I do it?

Read More
Escaping ampersand character in SQL string

I am trying to query a certain row by name in my sql database and it has an ampersand. I tried to set an escape character and then escape the ampersand, but for some reason this isn't working and I'm …

Read More
how to increase sqlplus column output length?

I have some queries to find out the ddl of some objects from a schema. The result columns I am getting are truncated in the middle of the queries. How can I increase the width of the column? I tried …

Read More