Oracle SQL Developer PL/SQL Packages Trick

You know how every TV show has to have that Christmas themed episode? No? Well, in the US, it’s pretty common.

And as a child of the 80’s television, my brain has been properly warped.

So here is your Christmas themed SQL Developer ‘trick.’

Every look under the tree, and your first reaction is to be a little disappointed in the number or shape of packages left for you?

Let’s say you like to code up your packages by doing up all specifications FIRST.

So, do that.

And then, you can do this.

This will look for a body, and add what’s necessary. Or if there IS no body, it will generate one for you.

Or, maybe you go the other way around.

You like to take lots of standalone procs and functions and consolidate them into an existing package, so you start with the BODY first.

Ok, so we have a partial spec…but two of my procedures need added.

So click, and then pick what you want to merge over.

And then voila.

See those little arrows in the gutter? If you click on them, you’ll auto-navigate to their spec/body counterpart.

Oracle SQL Developer PL/SQL Packages Trick – Synchronize!