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.

No comments :