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

ghz 1years ago ⋅ 2149 views

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

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](http://blog.andrewbeacock.com/2008/09/using-ampersands-without- variable_15.html).

#sql

ghz
- 8626Posts
- 0Comments
Favorites 0

Hot

1. Switch between two frames in tkinter?
2. Generating CSV file for Excel, how to have a newline inside a value
3. []byte(string) vs []byte(*string)
4. Kubernetes Service cluster IP, how is this internally load balanced across different nodes
5. PHP Startup Unable to load dynamic library php_mongo.dll
6. Make absolute positioned div expand parent div height

Latest

1. How to take a list and fill with values and put into a dataframe
2. Pandas join memoryError
3. python subprocess.call output is not interleaved
4. Execution timing with context manager
5. I want my ttk.treeview to have alternating colours
6. What are the differences in Pythons time.clock() in Mac vs Windo