SQL DataGrip formatting

I would like to know if it is possible to add/change the keywords which is being used in SQL DataGrip.

Namely, the no_data_found exception is not recognized as an Oracle keyword and it does not convert it uppercase.

One more, exception keyword is not aligned with begin statement, could this be fixed as well?

1
3 comments

I noticed really serious problem, when I copy large PL/SQL package over to DataGrip it loses "minus" sign and whole package becomes invalidated.

0

I have identified the issue down to two lines of code. E.g. If I copy and paste the following code into SQL worksheet, it loses "-" sign. This is serious issue, as it invalidates the whole package and it never compiles.

E:=EXTRACT(MONTH FROM FIRSTPAYMENTDATE)-
EXTRACT(MONTH FROM LOANSTARTDATE) ;

 

The details of the env.

IntelliJ IDEA 2016.3
Build #IU-163.7743.44, built on November 18, 2016
JRE: 1.8.0_112-release-408-b2 x86
JVM: OpenJDK Server VM by JetBrains s.r.o

0

Hi,
I've created an issue based on this phrase "the no_data_found exception is not recognized as an Oracle keyword and it does not convert it uppercase."
=> https://youtrack.jetbrains.com/issue/DBE-3551

Could you create another YouTrack issue for the second comment and specify how large is your PL/SQL package or give us package example to reproduce the problem?

Thank you.

0

Please sign in to leave a comment.