Re: searching for a '

The standard ' escape sequence is ''. In other words...

AND R."NAME" = ''''; Richard

Luciano Belotto wrote:
>
> Asking for help in searching a varchar2 field for a ' character. I try using
> the escape character in SQL plus as a / but no luck:
>
> SQL> show escape
> escape "\" (hex 5c)
>
> SQL> select * from "ODB"."RELATION_MASTER" R WHERE R."RELATION_TRANSACTION"
> = 'EMPLOYEE' AND R."NAME" = '\'' ;
> ERROR: ORA-01756: quoted string not properly terminated
>
> I'd also like to be able to put that query in a cursor in a stored
> procedure, but it doesn't let me compile that in Enterprise Manager.
>
> I'm using 9i on Win2000
>
> --
> Luciano Belotto
> replace spam with traxsoftware for e-mail
Received on Tue May 14 2002 - 15:23:32 CDT