Missing Functionality? - SQL Developer v TOAD
567369Mar 19 2007 — edited Apr 19 2007I'm in the process of trying to replace a number of TOAD installations with SQL Developer. While it is a great tool for reporting on an Oracle database, there are a number of areas where functionality is missing or not implemented. Inevitably, I have compared SQL Developer (1.1.2.25) against Toad Professional (9.0.1.8 with DBA module) and come up with the following list of missing functionality: -
Constraints missing from Object Tree
Java code missing from Object Tree
Formatting not editable (such as setting tab width)
Code Completion does not work
Schema Diff does not work
System "objects" not displayed in Object Tree (Users, Roles, Tablespaces, Rollback Segments, Resource Plans, Resource Groups, Directories)
In addition, the following would be really useful in making SQL Developer easier to use and faster to identify differences between objects: -
Identify partitioning
Display functions/procedures in Packages
Identify functions/procedures/packages compiled for Debug
Public synonyms incomplete in Object Tree (lots of ALL_* missing)
Finally, something else that would be incredibly good would be for the Oracle development people to create a "sticky" posting to cover this area. I feel a LOT of people are seeking to move from TOAD or would simply like to have quick and easy access to a resource where they can get an update on development of required features (and be able to contribute to this process).