Yes, another ‘Top 10’ list is here! Yes, it’s lazy. But, I’m all about lazy, and just because it’s lazy and overdone, doesn’t mean it has no value. If you’re new here or if you have a hard time catching up with all of your favorite bloggers and news outlets, here are my most popular SQL Developer posts, based on traffic, of 2012:
I’m not surprised this is #1 – and it wasn’t even close. Excel is THE tool for sharing and reviewing data. At some point, you’re going to want to shove that data back into Oracle. Thankfully, SQL Developer makes that pretty easy.
I have to thank @OracleAskTom for the assist here. He referenced this post in one of his FAQs. This post shows how to review your PL/SQL execution output, REFCURSOR or otherwise, in SQL Developer.
My favorite SQL Developer ‘trick’ – this undocumented feature allows you to add a custom hint to your SQL statement and have the script output pre-formatted to CSV.
Apple no longer ships OS X with Java pre-installed. It’s still pretty easy to get SQL Developer running on a Mac, but if you need help, this post is for you.
Did you know you can use SQL Developer to take your 1,000,000 line CSV file and setup a SQL*Loader run in just a few moments? Well now you do!
SQL Developer has a lot of options and preferences. Here’s a list of 10 you should probably take a look at.
Download, install, and run SQL Developer in less than 5 minutes (this post is on Windows, but applies to all environments.)
How DBMS_OUTPUT works in SQL Developer.
A collection of my favorite tips and tricks 🙂
You can use SQL Developer to query databases other than Oracle, but more importantly, you can also migrate them TO Oracle!
Thanks everyone for a great 2012. The SQL Developer team is busy putting together the next version of SQL Developer, and we’re expecting 2013 to be even better!