14 Replies Latest reply: Oct 11, 2007 10:00 AM by Turloch O'Tierney-Oracle RSS

    Escaping ampersand (&) in queries

      How 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,