There’s one big new feature:
- 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 –
![](https://www.thatjeffsmith.com/wp-content/uploads/2024/07/image-37-1024x653.png)
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
![](https://www.thatjeffsmith.com/wp-content/uploads/2024/07/image-38.png)
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.
![](https://www.thatjeffsmith.com/wp-content/uploads/2024/07/image-39.png)
SQL query calling function returning refcursor breaks grid and script output
![](https://www.thatjeffsmith.com/wp-content/uploads/2024/07/image-40-1024x703.png)
5 Comments
I’m waiting for Reports like in SQLDeveloper in VS
And you’ll get them soon, but first the stock reports, user define reports will come later.
Hi,
Is oracle sqldeveloper dead?
no new version?
No.
No – we’re about to release 24.2 with a new Java support (17), new features from SQLcl, and lots of bug fixes.
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.