Search Results

Tuesday, November 29, 2016

Notepad++ plsql function list

Locate functionList.xml file on the Notepad++ install location.

Add association map

<association langID="17" id="sql_node"/>

And the following parser

<parser id="sql_node" displayName="SQL Node" commentExpr="((/\*.*?\*)/|(--.**$))">
                  <nameExpr expr="^[\s]{0,}(function|procedure|--[1-9])[\s]{1,}\K[\w_]{1,}"/>

And finally restart the Notepad++

Now enable View -- FunctionList

This should bring you list of all functions and procedures in the current sql or plsql file.

You can click on it to navigate to selected code block.

Post a Comment