Can I use & in SQL?

How do I escape in SQL Developer?

Escape ampersand in PL/SQL Developer

1. Escape the & as & with set escape on.
2. set scan off (this causes an ORA-00922 missing or invalid option error)
3. 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.