SQL Developer Database Diff – Compare Objects From Multiple Schemas

thatjeffsmith SQL Developer 76 Comments

Ever wonder why Database Diff isn’t called Schema Diff? One reason is because SQL Developer actually allows you to select objects from more than one schema in the ‘Source’ connection for compares. Now, before you get around to testing this – as you should never believe what I say, trust but verify – two things you need to know: I’m …

‘Forcing’ Line Breaks in Oracle SQL Developer

thatjeffsmith SQL Developer 7 Comments

Oracle SQL Developer is at its heart, an Interactive Development Environment (IDE.) So it comes with the territory that developers should expect to be able to write good code quickly. One of the many code ‘helpers’ that a good IDE will provide is a Formatter. Formatters, or code beautifiers as they’re also known, take poorly formatted text and make them …

I Say Snippet, Snippet Good: SQL Developer Snippets

thatjeffsmith SQL Developer 13 Comments

There’s nothing worse than the ‘white screen of panic.’ You’re faced with the prospect of actually writing some code from scratch. Or even worse, you’re doing a presentation or demo, and everyone gets to see what a horrible typist you are. Yes, this is about Snippets, and Snippets are cool. But if you’re a keyboard person, then you’re gonna like …

Top 10 Tips & Tricks for Oracle SQL Developer

thatjeffsmith SQL Developer 62 Comments

Being a short week due to the holiday, and with everyone enjoying their Summer vacations (apologies Southern Hemispherians), I reckoned it was a great time to do one of those lazy recap-Top 10-Reader’s Digest type posts. I’ve been sharing 1-3 tips or ‘tricks’ a week since I started blogging about SQL Developer, and I have more than enough content to …