Oracle SQL*Plus has been around since 1985. It does what it does, and it does it well.
SQL Developer has been around since 2006. It’s become the de facto IDE and GUI for the Database.
There was an opportunity to build something new that could take the command line interface and enhance it to meet the needs of today’s database professional.
So really the question that our team was faced with wasn’t ‘Why?’ it was..
New folks to Oracle aren’t exactly thrilled when they discover most of the help docs and training materials are written to a command-line interface that is completely foreign to them.
Writing a simple SELECT * FROM query often leads to a result-set that trails off the screen and is near-impossible to read.
Basic things like recalling previous statements or getting help with your query or building new commands to make verbose things like a Create Table as SELECT or esoteric things like generating the DDL for an object – we could make those things available and so much easier.
So why not build that?
And that’s what we’ve done. Hopefully this isn’t a surprise seeing as I’ve been talking about SQLcl for more than a year now.
We’re starting to wind down the Early Adopter process. It’s going to be real, soon.*
* Soon – meaning I can’t say exactly when because legal, because other things, but you’ll see it go GA sooner versus later.
To the bigger questions some of you have been asking – when will this ship with the database and clients, what happens to SQL*Plus itself, etc., a few notes:
- SQL*Plus isn’t going away
- SQlcl will be available with your future Database and Client installs
- As with ALL of our tools – use the ones that make sense for the task at hand
I’m a big fan of choice. Our customers pay more than a little for their database licenses. They shouldn’t have to be limited to just a few, or even one, interface to their Database.
I’m not going to tell you which interface is the best one for you, but I’ll tell you what you need to know so you can make the right decision for yourself.
And who doesn’t like having choices? I usually have a piece of pecan and apple pie at Thanksgiving- just like I normally use both SQL Developer AND SQLcl most days.
Look for more news, demo’s, and a chance to provide feedback directly to us at KScope16 and Oracle Open World 2016.