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="((/\*.*?\*)/|(--.**$))">
    <function
            mainExpr="^[\s]{0,}(function|procedure|--[1-9])[\s]{1,}[\w_]{1,}">
            <functionName>
                  <nameExpr expr="^[\s]{0,}(function|procedure|--[1-9])[\s]{1,}\K[\w_]{1,}"/>
            </functionName>
    </function>
</parser>

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