How do I escape in SQL Developer?
Escape ampersand in PL/SQL Developer
- Escape the & as & with set escape on.
- set scan off (this causes an ORA-00922 missing or invalid option error)
- set define off (this causes an ORA-00922 missing or invalid option error)
How do you escape a character in SQL?
Backslash ( ) and the quote character used to quote the string must be escaped.
Table 9.1 Special Character Escape Sequences.
|Escape Sequence||Character Represented by Sequence|