Skip to Main Content

SQL Developer

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!

Partial parse tree in hierarchical query (bug?)

user9540031May 6 2022

Hello,
[SQL Developer 21.4.3]
Apologies if this has been reported before!
(Did I mention there might be room for improvement in the Search feature in this forum?)
The following hierarchical query is flagged as a syntax error (partial parse tree).
image.pngHowever, after adding a single blank character on line 7 before the start keyword...
image.png... the query is parsed successfully!
(Same if placing the start with condition before the connect by condition. SQL Developer's internal parser seems confused if the start keyword is found at the beginning of the line.)
Regards,

This post has been answered by thatJeffSmith-Oracle on May 9 2022
Jump to Answer
Comments
Post Details
Added on May 6 2022
3 comments
391 views