Oracle

ODC Appreciation Day : SQL Developer

Not sure if you’ve noticed, but there have been a few changes in Oracle’s advocacy community. The Oracle Technology Network has been rebranded as The Oracle Developer Community (ODC), and the Oracle ACE and Java Champions have a new baby sibling, called the Developer Champion. In the 2nd, hopefully annual Appreciation Day (started by Tim Hall), the community is releasing a series blog posts today, October 10th, to acknowledge all the great things shared within this community. Here are the rules:

  • The blog post title should be “ODC Appreciation Day : <insert-feature-name-here>
  • Write about a feature related to any Oracle product, not just database.
  • Tweet out the blog post using the hashtag #ThanksODC. If you have enough room, you might want to include #ThanksOTN as well for the sake of backwards compatibility.

Simple.

I’ve done a lot of posts about a variety of Oracle technology, but this one will go back to the content that I think put me on the map. Back in August 2013, I did my first post on SQL Developer describing a database migration from MSSQL to Oracle DB. So this post is for you SQL Developer.

SQL Developer has been the cornerstone of my development experience in the Oracle space. My first download was version 3.something, and I never looked back. Now running 17.3 (thanks to the new naming conventions) and it’s little yet powerful sibling SQLcl, life doesn’t get much easier when working in the Database. I have connected this tool to:

  • Oracle TimesTen in Memory Database
  • Every version the Oracle RDBMS from 9i to 12.2
  • MySQL
  • Access
  • MSSQL
  • Hive
  • and I’m sure I’ve forgotten something

There has been seamless connections over SSH to both cloud and my on prem database, and you can even deploy REST Data Services from SQL Developer.  The best thing is that as the Database matured and features were added, I could count on SQL Developer to be right there. Allowing me to manage PDBs when pluggable databases were introduced to migrating them into the cloud. Need to monitor your database instance? It’s in there! What’s the SQL ID? Yeah, you can get that. Explain plans, Tuning Advisor, yeah, all can be accessed in SQLDeveloper. The tool is just great.

Do you use #Docker? How about deploying and Oracle DB in a container and connecting that way? Yep! Works! Put everything in containers. Still works.

Oh, did I mention that SQL Developer and SQLcl are FREE? Mmhhmmm

I would be remiss, if I did not mention the team behind SQL Developer. You all are great. Special thanks however to the ones that I constantly harass on the rare occassion I have an issue:

  • Jeff Smith
  • Kris Rice
  • Ashley Chen

Please keep up the good work.

 Enjoy SQL Developer!!!