Re: How to suppress special characters in query

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Mon, 05 Feb 2007 22:16:21 +0100
Message-ID: <45C79EA5.8010306@gmail.com>

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
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>

SQL> set escape '\'
SQL> select * from tab1 where col1='A \& B';

COL1

---

A & B

Best regards

Maxim

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Feb 05 2007 - 15:16:21 CST