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 literal and brackets within string

user5716448Apr 1 2015 — edited Apr 2 2015

Hi,

Using 11.2.0.3 and using q literal

e.g v_sql_stmnt := 'q'['Total (Charges)' ];

works ok but our developer tool (pl/sql developer) seems to interpret the parentheses () differently in that shows key worrds like execute immediate in blue rather than green.

Without the () around Charges word colours and keywors highlighed as normal.

Anything funny with brackets and the q literal and how to treat it so colours be same as normal strings within quotes ?

Thanks

This post has been answered by unknown-7404 on Apr 1 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 30 2015

Added on Apr 1 2015

4 comments

1,172 views