15 thoughts on “SQLCL – The New SQL*Plus

  1. Great write-up!

    >>The TIME option shows the execution time for the first execution of a command.
    That should actually be showing the total execution time for that statement – just like the SQL History in SQL Developer.

    • Jeff,
      thanks for pointing that out. I’ve now corrected this in the post.
      I’ve also linked to your post about using DBMS_METADATA.SET_TRANSFORM_PARAM because it’s better than the one I came up with !

      Thanks again,


  2. OK. I’m finally convinced that SQLCL is a good thing. The best since sliced bread, so to say.
    …. unfortunately … my work machine has only Java 1.5 and sqlcl tries to download a new version of java. Need to find a better organisation that will give me a job.

    • Hemant,
      assuming your work machine isn’t locked down and you are able to download the JRE yourself, I think it’s possible to run multiple JRE versions concurrently.
      Of course, you’d probably need to ensure that the 1.7 JRE wasn’t included in your path, but you could explicitly point SQLCL at it.
      Jeff has a post on Installation of SQLCL which may be helpful.



    • Mick,

      I haven’t found one. I also had a look at SQLDeveloper itself and couldn’t see anything along those lines.
      It’s probably worth asking on the SQLDeveloper forum as there may be a way to do this. If not, you could always ask them if they can add it as a feature.



    • Stephen,

      yes, you can :

      SQLcl: Release 4.1.0 Beta on Sat Sep 05 10:11:41 2015
      Copyright (c) 1982, 2015, Oracle.  All rights reserved.
      Username? (''?) sys as sysdba
      Password? (**********?) ********
      Database? (''?) XE
      Connected to:
      Oracle Database 11g Express Edition Release - 64bit Production 
      SQL> show user
      USER is "SYS"



  3. Pingback: SQLcl: The new challenger for the SQL Plus crown – All Things Oracle

  4. Pingback: SQLCL – The New SQL*Plus | Christoph's 2 Oracle Cents

  5. Loving SqlCL with one exception. How do I terminate a long running statement? Example:
    select * from user_objects;
    This will spit out thousands of rows. How can I terminate the output?
    Loving the tool!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s