In this article we will look into a SQL Developer like tool for Oracle Cloud. We have already seen a similar tool earlier but it doesn’t work post 20D update as REFCURSORS are not supported by Oracle post 20D.
Oracle has released a notification earlier that REFCURSORs are not supported post 20D and most of the tools that were designed earlier using REFCURSORS stopped working or the developers will have to devise an alternative.
Here I come up with another FREE cloud based SQL developer like tool which works post 20D as well. They have designed this tool without REFCURSORS so this tool works post 20D. I have tested this myself to confirm that and here is the genuine review of the tool.
I also got a chance to talk to their Technical Architect/Director Binuraj Nair who was very supportive and provided the background of this tool, its functionality and their roadmap for future.
It’s a cloud based tool hosted on Oracle Cloud Infrastructure(OCI) and they have plans in next year to create an offline version of the tool. DataFusing has created this tool for internal purpose and they are giving back to community by making it free for everyone which is echoed in the message on their website.
Here are the main features of this tool:
On the security front also they aren’t storing any credentials on their database and all the SQL run requests are passed using collections and doesn’t hit their database at all.
Here is their FAQ section
DataFusing team is working on adding additional functionality to this tool.
As the password isn’t stored on their database, we will have to enter the password everytime we login to their system or everytime the session expires.
Here is how the UI of the tool looks like:
They have also included a public library with the sample SQL queries for some objects.
We can also add the frequently used queries to our library which is specific to the logged in user. We also have option to contribute to the public library.
Overall I feel this tool can be used to run ad-hoc queries. It would have been better if it was an offline tool which I have also provided as feedback to their team. And they replied in positive tone of taking it up in the near future.
This is my genuine review of this tool and not to be considered as a promotion of any sort. Please do your due diligence before using this tool.