Install | Changelog

There’s one big new feature:

  1. Graphical User Interface for JSON Relational Duality Views
    • build new or edit existing views
    • generate SQL or GraphQL syntax
    • test the view – easily query the data
    • generate a diagram for the view
    • easily set properties for each attribute or parent

Here’s a quick glance at how that’s presented in the extension –

Some of the improvements fall outside of the 23ai and Duality View feature, so if our Single Record Viewer sees that you only have a single column and it’s JSON, we’ll give you that nice and pretty printed JSON viewer.

Expect an in-depth follow-up post where I take you on a FULL TOUR of all the JSON Relational Duality View features!

And many, many bug fixes!

A few of these might be more interesting than others, including but not limited to:

Cancel long running queries correctly

That just wasn’t working, and now it should be!

Remove sql-developer prefix from snippets

The code completers should be MUCH less eager now, and ultimately more useful.

Having ‘SQL Developer’ in every snippet name wasn’t helpful based on how VS Code does fuzzy searches.

SQL query calling function returning refcursor breaks grid and script output

Author

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

5 Comments

    • And you’ll get them soon, but first the stock reports, user define reports will come later.

    • No.

      No – we’re about to release 24.2 with a new Java support (17), new features from SQLcl, and lots of bug fixes.

  1. I don’t know if this feature exists, but it would be very helpful to have an option above each procedure in the package that shows a reference list of where it is called from. When clicking on the option, it would open a list with information and with option link. I believe this would significantly speed up the development process.

Write A Comment