Harvinder Singh schrieb:
Hi, We have a query like following that includes the & symbol and since this is a special character so Oracle prompts for the input. Is there any way to suppress this special character in a query without using the set define off option at sqlplus session? Select * from tab1 where col1 like = 'A & B' Thanks --Harvinder -- //www.freelists.org/webpage/oracle-l
SQL> set escape '\' SQL> select * from tab1 where col1='A \& B'; COL1 -------------------------------------------------------------------------------- A & B Best regards Maxim -- //www.freelists.org/webpage/oracle-l