Skip to Main Content
Forums

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!

Parser can not parse the correct code:{ MEASURES (0 result, MAX(dummy) OVER (PARTITION BY dummy) mdu

2907631Feb 1 2019 — edited Feb 5 2019

The code below is compiled and executed in Oracle Database 18c (18.3), but the parser (18.4.0.376) cannot parse it.

Is this some kind of problem with parsing?

SELECT result, dummy, mdum

FROM dual

MODEL RETURN UPDATED ROWS

DIMENSION BY (dummy)

MEASURES (0 result, MAX(dummy) OVER (PARTITION BY dummy) mdum )

RULES(

    result\[5\] = 1,

    result\[6\] = 2,

    result\[7\] = 3

)

parser_syntax_error_2019_02.png
This post has been answered by Vadim Tropashko-Oracle on Feb 4 2019
Jump to Answer
Comments
Post Details
Added on Feb 1 2019
#sql-developer
2 comments
226 views