SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01756: quoted string not properly terminated (using (q) operator

SmileMay 11 2010 — edited May 13 2010

Hi

I tried this example but giving the error

select q'( it's done )' from dual

but the following is working

select q'( it''s done )' from dual

If i need to use it''s done then what is the use of (q) operator

Thanks..

Edited by: josh1612 on May 10, 2010 11:09 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 10 2010

Added on May 11 2010

5 comments

1,928 views