

UPDATE – new feature added in Oracle SQL Developer 18.3 I haven’t worked out how to include these in the rule yet.Įnhancement Request for SQL Developer for users of Logger The only thing missing is that it doesn’t pick up the standard logger variable declarations (scope and params). I’m not very familiar with the syntax but you can add additional libraries by adding more lines like this to the rule: You can view (and edit, if you want) the rule in PL/SQL Custom Syntax Rules: You can customise the colour for this rule in Tools -> Preferences -> Code Editor -> PL/SQL Syntax Colors – the one for logger etc. Any calls to logger, dbms_output and apex_debug will be greyed out. Oracle SQL Developer 18.3 adds this feature with PL/SQL Custom Syntax Rules – and the best thing is, these rules are enabled by default so you don’t have to do anything.


Custom Syntax Highlighting in SQL DeveloperĪ few years ago I raised an enhancement request for SQL Developer to add custom highlighting, specifically to “grey out” all the calls to logger throughout my code.
