Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Using ' character in string in where statement
Christian Svensson wrote:
> Greetings,
>
> I hope someone can help me with this maybe "stupid" question. I have
> looked at otn and in this newsgroup but cant find anything.
>
> If I want to use a ' character in the string in my where statement,
> how do I do then ?
>
> for example select something from some_table where some_col = 'my '
> character'
>
> Thanks for any answers.
>
> Cheers !
>
> /Christian
In sqlplus, you can do something like this:
set escape on
select something from someplace
where publisher = 'O''Reilly \& Associates';
Received on Fri Jan 17 2003 - 12:50:36 CST