Re: How to suppress special characters in query
- From: Carel-Jan Engel <cjpengel.dbalert@xxxxxxxxx>
- To: Harvinder.Singh@xxxxxxxxxxxxx
- Date: Mon, 05 Feb 2007 22:15:04 +0100
Entering
'oracle SQL special character'
In the google search box led me to:
http://orafaq.com/faq/how_does_one_escape_special_characters_when_writing_sql_queries
(2nd hit)
Please keep in mind that this list is not a search engine, nor an
automagic answering machine.
A little effort and research is expected and required, before turning to
the list, otherwise you might find yourself being ignored when you come
up with a serious question.
Best regards,
Carel-Jan Engel
===
If you think education is expensive, try ignorance. (Derek Bok)
===
On Mon, 2007-02-05 at 16:02 -0500, Harvinder Singh wrote:
> 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
>
>
Other related posts:
