Tool for navigating code in PL / SQL

Question

I need to study and modify a large and poorly documented code base written in pl / sql. I use Oracle SQL Developer to navigate it, but it gets tedious because there is no “go to declaration” or “find ways to use” option, so I need to go manually to the specified package to find a function or procedure that I want to understand , or grep for an offline copy to find usages.

I tried installing vim + ctags, but violent ctags get confused by case insensitivity.

So the question is, which tools make it easy to navigate through the PL / SQL code?

Answer 1

PL / SQL Developer , from Allround Automations there are some nice features for navigating code. You can download and install a fully functional trial version, which will last one month. Subsequently, if you like this tool and want to use it, you will have to pay a (modest) fee.

Answer 2

Try Tobys PLSQL Editor . He gives you:

• Syntax highlighting
• F3 go to code
• Package Descriptions
• Code ending
• Compile a database with highlighting
• Generating an automatic header using PLDoc

. , / .

Answer 3

Exuberant ctags ctags PL/SQL, , , , Emacs vi. Sublime Text 2, 3000+ . (ST2 - , , SQL, ).

Exuberant , , , , ( ).

Answer 4

Oracle SQL Developer Quest TOAD, ! TOAD, . , , , TOAD , SQL Developer "".

Answer 5

SD , , grep, , . , langauge, , . .

PL/SQL, (C, ++, #, COBOL, Java,...).