Oracle SQL Developer version 4.1 Early Adopter Now Available

thatjeffsmith SQL Developer 29 Comments

Tell Others About This Story:

Go get it.

Then come back here and read a couple of things.

  • it REQUIRES Java 8
  • it’s not production ready – send feedback to the Forum not to Support

Two new features to help you get started.

SQL Formatting in the Worksheet

Like the /csv/ formatting ‘hints’ you can add to your statements? Well now, you can just toggle that output mode for an entire session.

SET SQLFORMAT ...

SET SQLFORMAT …

You ‘unset’ the formatting by using the ‘set sqlformat’ command with no arguments. So if you want to spool 3 queries out to files, now you can set the format once, and not muck with your queries at all. And if you want to automate that via an OS script, keep reading 🙂

File Dialogs

Exporting the same file to Excel, over and over again?

Most of the file open and save dialogs will allow you to re-open or re-save file names/directories. This is going to save you a LOT of time – we hope!

Note the drop-down control on the file-picker

Note the drop-down control on the file-picker

There’s More, Much More

Be sure to also follow Kris’ blog. We’ll have a lot to talk about over the next few months. He’s quite excited about this font stuff, and pretty colors you can do up in a command prompt now. So expect lots on that from him.

Next I’ll talk about one of the most popular features in the tool, and how we enhanced the workflow to make it faster and automatable – loading Excel and delimited data to Oracle using SQL Developer.

Related Posts Plugin for WordPress, Blogger...
Tell Others About This Story:

Comments 29

  1. Is there anyway, without writing specific scripts, to get to see the Monitor SQL/Session to show all of the Nodes instead of just a specific one connected to? I am running on Exadata and I have 4 Nodes available. A problem “job” is on Node 2 as found from Monitor_Session. I start the Monitor_SQL on Node 2 but I see nothing for the job in question.

    1. thatjeffsmith Post
      Author
  2. I am just trying out v4.1 and I would like to please know where or how I get to see the results of a query I write in the worksheet. Before the results would show at the bottom. Now I have the whole page for the worksheet and that is all. Two tabs Worksheet and Query Builder

    Regards

    1. thatjeffsmith Post
      Author
      1. Sorry to be so dense .. but where would I find this un-minimize button? All I see are two arrows at the bottom up and down in black. The cursor changes as I go to the bottom into something that suggests I can drag the line but even this does not do anything.

        Resetting the window to Factory defaults does not do anything either

        This is the first time ever in SQL Dev that query results do not automatically pop-up

        1. thatjeffsmith Post
          Author
          1. thatjeffsmith Post
            Author

            Then something’s wrong with your ‘install.’ Do you see anything in the log panel, a warning or error perhaps? You might need to run in debug mode to see what’s actually happening.

            Or try extracting 4.1 from the zip again, and saying ‘no’ to importing settings from a previous install.

      2. I did a reinstall and with No to the import of preferences. everything worked fine!
        When I was then resetting my preferences
        Database for the connection startup I had a file that would do
        set serveroutput ON size 1000000
        which was causing the problem. Removing the preference made things fine again.

  3. Hi, I use a lot “select /*csv*/ * from table”, but with this new release it doesn’t seem to work! There are any preferences to set?

    1. thatjeffsmith Post
      Author
  4. The animation (that looks sort of like a translucent ticking clock) seems to really slow things down on my computer. The delay is especially noticeable when updating child reports. Is there any way to disable this animation?

    1. thatjeffsmith Post
      Author
      1. Gosh, wow, I know I’m late to the party but that big animation is awful. Just switched to 4.1.0.17 from 3.1.07. Please give option to disable. I may have to go back to V3. (Sorry to be negative — all else looks good so far.) Thank you.

          1. thatjeffsmith Post
            Author
  5. I’m trying to run this from a USB drive (no admin rights on my work PC). I’ve installed JDK8 onto the USB drive and set the path (java -version shows 1.8.0_25), but every time I start the new SQLDeveloper it says I’m using V1.7. I’ve updated the product.conf file to point to the V8 JDK but no luck.

    Has anyone got this to run from a USB? The previous version runs OK from one.

    It would be nice if the JDK was bundled with it as it was with the previous version, makes life a bit easier.

    1. thatjeffsmith Post
      Author

      did you read my post from yesterday? there’s your answer – update the product.conf to force the jdk8 to be loaded

      we’ll bundle Java with the windows dist once we go official release. we don’t bundle the JDK with the Early Adopters

      1. Hi,
        I did update the product.conf (mentioned it in my first comment).
        I’ve now got it working by renaming the product.conf which forced it to create a new one which I could edit and add the path to the V8 JDK.

        Looks good, thanks.

      1. thatjeffsmith Post
        Author
  6. First of all, thank you for your effort!
    I am trying to check new features, but I am not able to find announced Instance Viewer in SQL Developer 4.1.

    Thank you for your assistance.

Leave a Reply

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