Skip to Main Content
Forums

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!

Q-Quote operator.

WoyswerMay 11 2013 — edited May 12 2013
I am using Oracle version 11g and learning about this Q operator.

When i run the following statement

select q'{This is Oracle's World}' Text1, q'[This is Oracle's World]' Text2 from dual;

Result is: This is Oracle's World This is Oracle's World

When i run the following statement

select q'{This is Oracle's World}' Text1 from dual;

Result is : ORA-00911 : invalid character

Can someone please tell me why this is happening?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 9 2013
Added on May 11 2013
8 comments
2,395 views