Re: SQL quoting question

In SQL*Plus, you need

    set escape=\

to use the backslash like you're used to in Unix. If only the ampersand is giving you trouble, as SQL*Plus will prompt you to enter a value, then consider using another parameter identifier, like the ^, using

    set define='^'

However, as you ask for quoting the underscore and % as well, I guess you're using LIKE(..). Suppose you want to search for anything containg a percent sign. Then use:

    where replace( my_column, '%', '@' ) like '%@%'

Arjan. Received on Sun Jul 19 1998 - 02:54:15 CDT