Normally when someone asks me about ordering packages, I check the doorstop for our daily Amazon delivery. Ok, it just seems that way, and I’m lucky that my awesome wife/partner doesn’t read this blog…
…but what we’re really here to talk about is finding stuff in your PL/SQL package.
I think there are 2 types of folks:
- Those that code willy-nilly: they build out each variable, procedure, type, function as it pops into their mind
- Those that pretend they’re not in group 1
Unfortunately when it comes to browsing your PL/SQL, that well crafted package declaration comes back to bite you.
So what’s a developer to do?
Have it your way, right-click
By default we show it the way the developer wanted you to see it – as it’s coded.
I think this one is probably the most logical way to go if you’re going to change things up.
I’m right-clicking ON a package member to get this context menu, but it’s on the package itself as well, just with all the other things.
If you want a fun package to test this with, then I suggest giving SYS.DBMS_METADATA a go.
3 Comments
That is cool. But it would be way cooler if when I am editing the file (say from my source code repository) I could also see the tree with the members of the package.
Also, maybe as I am navigating or setting the cursors in areas of the code, the specific member on the tree gets highlighted.
Right click in the code editor. Open the code outline panel.
Right-click, Code Outline. It does exactly what you’re asking for.