Mostly Making oracle easy, mostly:
Search for:

Ask A Question

Nearly 7,000,000 Oracle professionals use SQL Developer on a regular basis. Have a question about Oracle SQL Developer? Searched this blog and couldn’t find the answer? Ask away!

If your question is about Oracle Database, SQL, PL/SQL, etc – go Ask Tom!

Feel free to ask anything you want, but I’ll feel free to send you to Support or our Forums if it goes sideways.

Note: This page has turned out way more successful(?) than I would have ever imagined. Please keep these things in mind when asking questions.

  1. I am NOT support. Don’t expect me to log bugs for you, or give you official timelines on bug fixes, enhancements, or product releases.
  2. I AM NOT SUPPORT. Don’t open an SR with My Oracle Support AND leave a question here. Pick one and go with it, and when in doubt, go to My Oracle Support.
  3. I try to answer questions as quickly as possible. If you don’t get an answer, ask me for an update. I may have just forgotten or overlooked your request.

Go!

7,931 Comments

  1. Wayne Adams Reply

    Jeff, do you have any instructions for getting sqlcl to work with Graalvm 21 (jdk 21?) with Javascript support? All the existing documentation I can find talks about using “gu” to install the js support for a graalvm installation, but “gu” is no longer shipped with graalvm 21. And i can’t make sense of the instructions on the graalvm js github site for adding it and can’t seem to find any post where others have documented the process.

    • thatjeffsmith Post Author

      External/Just in Time plsql debugging where you start a local listener and attach to another session, not YET implemented in our VS Code extension.

  3. Jayson Garrett Reply

    Hi Jeff,

    I’ve been scouring the web for a definitive way to do this, and have found varying things. I was hoping you could clarify how to create a tab-delimited file using SQLcl. I’ve seen mentions of using COLSEP CHR(9), an old post where you mentioned JS (but what JS?), etc. Is there a current way to do this with SET SQLFORMAT (or any other means) in SQLcl? Currently, I’m using 22.4, as the machine I’m using it on is required to have Oracle Client 19c only. Thanks for any help you can give!

    • thatjeffsmith Post Author

      You need to upgrade to 25.1

      then you can do this –


      --wrap this with a spool file.tsv and spool off
      SQL> set sqlformat delimited \t ' '
      SQL> select * from countries fetch first 5 rows only;
      'COUNTRY_ID' 'COUNTRY_NAME' 'REGION_ID'
      'AR' 'Argentina' 20
      'AU' 'Australia' 40
      'BE' 'Belgium' 10
      'BR' 'Brazil' 20
      'CA' 'Canada' 20

  4. Jack H Reply

    Hey Jeff – do you know if there are any plans to add functionality in the new VS Code extension to give me a notification when I log into one of my connections that my password is going to expire soon? It used to happen in the old SQL Developer Java version which was useful so I knew to change it before it expired, since it wasn’t possible (as far as i know) to change the password after it expires through the SQL Developer app and I had to go to through the SQLPlus (now SQLcl CLI tool) to change the password.

    Many thanks,
    Jack

    • thatjeffsmith Post Author

      If we’re not surfacing that message, it’s a bug. I’ll look into it.

      OK, I looked into it, it’s a bug! Will file and sort this for you.

      Thanks for your report!

  5. John Thomas Reply

    We have our own tailored data dictionary viewer, implemented using node.JS.

    Thinking it might be a nice feature if we could add a button to call out to an API that generates a model diagram, as SQL Developer does.

    • thatjeffsmith Post Author

      Theoretically yes, it’s there for SQL Developer Web –
      but
      1 – requires ORDS
      2 – assumes dictionary is in an oracle database

  6. John Thomas Reply

    Jeff, is there any prospect of an API to create models the way SQL Developer does when you click on a table and it returns the immediate neighbours?

    • thatjeffsmith Post Author

      An API to create a model? How exactly would you use this API, or what would the expected output look like?

Write A Comment