Using an older version of SQL Developer may be an option for you. Deprecating Query Builder third-party DB functionality in more recent versions gets a brief explainer in...
So technical the current version will not work?
As I am not sure which version are you referring to...
Thank you for your help.
1 person found this helpful
As I recall, starting with the 3.0 release, SQL Developer licensed a third-party tool (see ActiveQueryBuilder.jar) to replace the old query builder. That tool offers support for multiple flavors of SQL on multiple RDBMS platforms. The problem was, our team started to hear about issues with Query Builder on those non-Oracle RDBMS as well as issues with more complex Oracle SQL queries that the third-party tool did not properly handle.
For various reasons, including limited control over bug fixing by the third-party and a focus on supporting migration to Oracle from third-party RDBMS, a decision was made to take the position that Query Builder is provided as a tool for non-expert Oracle SQL programmers.
I do not recall exactly when support for non-Oracle SQL got disabled, but you can start with the 3.2.2 release to see if that still enables it...
...and chain backward (see link at the bottom of the page) to earlier release if necessary.
Hope this helps,
SQL Developer Team
Just to let you know that I tried the version Oracle SQL Developer 3.0 (3.0.04.34), and it worked.
Versions after that are not working...
we nuked it because we don't want folks depending on SQL Developer for features in databases other than Oracle. we bring you the 3rd party database connectivity for migration support only. anything you use it for other than that is your business, but we won't be accepting feature requests for bug reports unless it's Migration-related