Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Missing Functionality? - SQL Developer v TOAD

567369Mar 19 2007 — edited Apr 19 2007
I'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).
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 17 2007
Added on Mar 19 2007
15 comments
3,154 views