Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ' in query
You have to type the ' twice. 'select * from table where name = ''A''';
This should work, I've used this many times myself.
Regards,
Wim Valgaeren
<buurd_at_my-deja.com> wrote in message news:80rd2d$ndj$1_at_nnrp1.deja.com...
> Hi!
> I'm trying to find out how to make this work:
> select * from queries where query = 'select * from table where name
> = 'A'';
>
> I've tried to escape with:
> select * from queries where query = 'select * from table where name =
> \'A\' ';
> but got the same error.
>
> I also tried
> select * from queries where query = 'select * from table where name =
> {'}A{'} ';
>
> but that didn't work either. Those was the solutions I found in the
> documentation but i'll guess they escaped somehing else...??
>
> How to do this??
>
> tia
>
> --
> Roland Carlsson
> Certified Java programmer
> Skövde
> Sweden
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Nov 16 1999 - 07:04:04 CST