Skip to Main Content

SQL Developer for VS Code

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!

Highlight variables/parameters in a different color

chrisdevMar 6 2024

Imagine I have a variable lv_my_var.

If I have some code:

SELECT col1, col2, col3, lv_my_var FROM my_table;

Currently the syntax highlighter makes the columns and the variable the same exact color. It would be great if SQL Developer could detect variable/parameter names from a declaration section and highlight variables in a different color or allow users to define custom patterns that should be highlighted as variables (for my workflow, local variables always start lv_, parameters start p_, etc.).

This would code much more readable at a glance. The “Language PL/SQL” extension supports this and it is a great feature, but not compatible with the official Oracle extension.

Comments
Post Details
Added on Mar 6 2024
0 comments
264 views