More on Working with PL/SQL Packages – Ordering their Contents

thatjeffsmith SQL Developer 3 Comments

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 …

Adding Columns to a Table in SQL Developer Data Modeler: Honor Column Order?

thatjeffsmith SQL Developer 0 Comments

I have an employees table. Because it’s 1984, HR has decided we need to know Twitter handles, Facebook pages, and who knows what else. So let’s add it to our table. The dialog by default puts new columns at the bottom of the table. We’ll see why in just a moment. On a side note, we’re not super fond of …