Code highlighting enhancement request

[Michael D]

Consider the following query:

select start_date
, end_date
, lead (start_date) over (order by start_date)
, lag (end_date) over (order by start_date)
from my_table

The query uses the Oracle analytic functions LEAD and LAG. When viewed in an SQL window, the keywords lead, lag and over are correctly highlighted. When used in a program window, however, the keywords are not recognized and not highlighted. I tested a few other analytic functions like RANK, MEDIAN and LISTAGG and neither of those are highlighted in a program window. LISTAGG isn't highlighted in an SQL window either.

My request is that the analytic keywords are highlighted in both windows.

Best regards
Michael Doel
Truston Solutions B.V.

 

[Marco Kalter]

I have added this to the list of enhancement requests.

Note that you can already implement this yourself by moving the corresponding keywords from the

 section to the [PLSQL] section in the default.kwf file in the PL/SQL Developer installation directory.

 

[Michael D]

Thank you, I didn't know about the default.kwf file. The keywords are highlighted correctly after editing the file.

Best regards
Michael Doel
Truston Solutions B.V.