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.