Menu
I'm currently using Oracle SQLDeveloper a lot more that I have ever used and I'm starting to like the tool.
I use Shift+F4 a lot to jump into a package/function/procedure. But one thing that I don't really get is how to jump directly to the package body or as an alternative some kind of shortcut that toggles between the spec and the body of a package.
Toad has something like this and I'm unable to find this feature in SQLDeveloper.
I'm also aware that you have the object tree on the left side of the screen but it's not really the best way to navigate to a package body when you are already looking at its specification. Especially if you have something like 300 packages with similar names...
For someone that uses SQLDeveloper to work everyday and does a lot of development with packages there has to be a way to do this...
I'm hoping for some magical shortcut or some obscure plugin.
637
A PL/SQL package consists of two parts: package specification and package body. If the package specification has cursors or subprograms, then the package body is mandatory. Otherwise, it is optional. Both the package body and package specification must be in the same schema.
Can we create a package Specification without body ? Yes, and these are quite useful when the package only contains variable and/or type declarations, e.g.
The body contains the detailed code of the subprograms. Variables can be declared in the body. The specification must be created before the body.
Right-click on the body of the stored procedured from the database. select compare option. select with other file option.
see the picture above-- the downward pointing side arrow -- click on it-- it will open up the function defintion. thanks
192
After opening the package spec using Shift+F4, press Ctrl+Shift+F12 to open or toggle between body and spec
32
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
