String literal (q'! !') causes subsequent code not to be formatted correctly i.e it highlights code after in red. (4306658)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

String literal (q'! !') causes subsequent code not to be formatted correctly i.e it highlights code after in red.
Description

When using String literal (q'! !') format, specifically using the exclamation point (!), code after the literal highlights incorrectly.
Example: SELECT q'!'!' Val FROM Dual
Resolution

WORKAROUND

Use brackets {} or [] instead of exclamation point (!) e.g. q'[']'

STATUS

Fixed in version 12.9. The latest version can be downloaded here.
Defect ID

TOR-893

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title