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:{ CAST(SYS_EXTRACT_UTC(SYSTIMESTAMP) AS DATE) - (1/86400); } P

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?

declare

v date := CAST(SYS_EXTRACT_UTC(SYSTIMESTAMP) AS DATE) - (1/86400);

begin

null;

end;

This post has been answered by Vadim Tropashko-Oracle on Feb 4 2019

Jump to Answer

Added on Feb 1 2019

#sql-developer

2 comments

3,441 views