Escaping ampersand (&) in queries
51564Jan 23 2007 — edited Oct 11 2007How do I escape an ampersand in a query executed in the SQL Worksheet in SQL Developer? For example if my query is:
SELECT * FROM EMPLOYEES WHERE status = 'Hired &Fired';
If I execute this query now in SQLD, it asks me to enter a parameter for &Fired, whereas in this case, ampersand is a value in the column status in this table.
Thanks for all the help,
Alex