Sell Me on Oracle SQLcl in 50 Seconds

thatjeffsmith SQL Developer 5 Comments

Tell Others About This Story:

Why would I use SQLcl over something else?

History recap: we introduced a new command-line interface for the Oracle Database in 2016. It’s everything you like about SQL*Plus, and everything you didn’t like about SQL*Plus – fixed.

Do you have a minute?

Watch this, then take 10 seconds to consider how YOU might use it.

Sold yet?

Everyday Things, Easier

Just in 50 seconds I showed you:

  1. Object completion
  2. In-line editing
  3. Automatic SQL Formatting (pretty and CSV)

There’s so much more there though. Better takes on DESC, SQL History, new commands like CTAS, DDL. The ability to change your directory for spooling and @ files (cd).

If you’d like a longer take, here’s a 50 minute full presentation on SQLcl I did earlier this year.

Or if you just want to click through some slides right-quick:

Yes, it’s an Official Product

It’s included with your Database license. It’s distributed with the database. And it’d covered by My Oracle Support. We also give you quarterly updates with new features and bug fixes. We also have our own OTN Space Community (message board.)

Enjoy!

Related Posts

Tell Others About This Story:

Comments 5

  1. The one thing that bugs me is the handling of the start directory in sqlcl.

    I start sqlcl from directory x/y/z and want to work my way interactively through some scripts. But the notion of start directory for sqlcl seems to be some directory in the oracle installation itself.

    What is the most simple way to make sqlcl do what I want here ?

    Tanks for listening and considering !

    Norbert

    1. thatjeffsmith Post
      Author

      I think you will like the CD command – it affects both looking for and writing out files

      SQL> SHOW sqlpath
      SQLPATH : C:\Users\jdsmith\Desktop\sqldeveloper\sqldeveloper\bin\;.
      SQL> cd c:\users\jdsmith\documents
      SQL> SHOW sqlpath
      SQLPATH : C:\Users\jdsmith\Documents;C:\Users\jdsmith\Desktop\sqldeveloper\sqldeveloper\bin\;.
      SQL>
  2. Hi Jeff,

    I really like Sqlcl, congrats to the developers.
    I still encounter some minor annoyances that wouldn’t be an issue on Sql*Plus like for example:

    SQL> col serial# for 999999
    SP2-0158: unknown COLUMN option “#”

    Am I missing something?

    SQL> show version
    Oracle SQLDeveloper Command-Line (SQLcl) version: 18.2.0.0

    SQL> ! java -version
    java version “1.8.0_181”
    Java(TM) SE Runtime Environment (build 1.8.0_181-b13)
    Java HotSpot(TM) 64-Bit Server VM (build 25.181-b13, mixed mode)

    1. thatjeffsmith Post
      Author

Leave a Reply

Your email address will not be published. Required fields are marked *