Skip to Main Content

Database Software

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!

Allow Nested Multiline Comments

nemecjMar 24 2019 — edited Mar 24 2019

In some situations the posibility to use a nested multiline comments would be usefull.

Those cases include:

* examining several variants of a subquery by commentig out the alternatives

* adding the execution plan to the SQL script as a comment

* generating the SQL query and adding the parameters as comment

All those cases can lead to a nested comment such as

/*

This is the query

   select /*+ parallel(2) */ from dual

*/

Currenly the nested comment end must be "escaped" such as bellow to get a valid syntax:

/*

This is the query

   select /*+ parallel(2) *_/ from dual

*/

The idea is to use similar mechanism as for the Q delimited strings to allow the nested commens without escaping

For example

/*q'{ comment may contain the end of comment sequence */  }'*/

or

/*{ comment may contain the end of comment sequence */  }*/

Comments
Post Details
Added on Mar 24 2019
1 comment
1,053 views