Contents
show
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 |
---|---|