escape sequence

[kiyoka]

I followed metalink and tried the following with error. Does anyone have other suggestion? Thanks in advance.

SQL> set escape SQL> set escape on
SQL> select * from dual
2 where dummy ='O/'Reilly' escape '/';
ERROR:
ORA-01756: quoted string not properly terminated

 

[karluk]

The following query will work. It uses two consecutive single quotes. That's how to embed a single quote within a string.

select * from dual
where dummy ='O''Reilly'

 

[kiyoka]

Thanks
Wow, this site is better than Metalink!