AMPERSAND in where clause mistaken for variable name

Hi everyone,

I have a query which is as follows

SELECT

        column_1,
        column_2
FROM
        table
WHERE
        column_3 = 'ABC&DEF';

The problem is 'ABC&DEF' represents a value in the table, but because of the ampersand oracle mistakes it for a variable which has to be input and prompts me for DEF.

My question : Is there a way to make oracle understand that 'ABC&DEF' is a data value in the column and not prompt me for DEF.

Any input would be very much appreciated.

Thanks for your time and have a good day.

regds,
Jude

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet