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!

thatjeffsmith
Author

I'm a Senior Principal Product Manager at Oracle for Oracle SQL Developer. My mission is to help you and your company be more efficient with our database tools.

7 Comments

  1. Hi Jeff,

    Can you tell me that in sql developer how to set same as Toad of line terminating same as Toad for example press Enter only and code formate is also same as Toad formate because sql developer code formate is very unusable.

    Regards,
    Shahnawaz

  2. 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

    • thatjeffsmith

      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>
  3. 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)

Write A Comment