On 2/5/07, Harvinder Singh <Harvinder.Singh@xxxxxxxxxxxxx> wrote:
I tried the google and don't want to use the set option and the escape sequence specified in article is not working (I am not sure if it works for &). Following is the output from sqlplus: SQL> select * from tab1 2 where col1 like 'A \& b%' ESCAPE '\'; Enter value for b: It works as an set option but not in the query and I was looking for something to work in the query without the set option: SQL> set ESCAPE '\' SQL> select * from t_account_mapper 2 where nm_login like 'A \& b%';
Why is it that you don't wish to use the sqlplus feature designed for this purpose? This looks like a one-off sqlplus script, why not use sqlplus commands in it? If you are using this sort of construct in a program of some description I recommend using select * from t_account_manager where nm_login like :1; and build up the bind variable accordingly.
-- Niall Litchfield Oracle DBA http://www.orawin.info