RE: SQL Developer vs toad for oracle

Something that Toad does very well that SQL Dev does not seem to handle at all: objects.

When your function returns a record set with nested structures, Toad shows the record and allows you to "drill down" into the data.  This allows you to quickly view the data you are focused on.

On the other hand, SQL Dev shows only what SQL PLus would: a long text string with the values comma separated and in brackets to show the nesting.  You have to work through the structure yourself to identify exactly which data you're concerned with.

Is there a plugin in the SQL Dev community that handles that?  I don't know.  We're not allowed to install anything on our PC's so the efforts to get a plugin installed is generally not worth going through in the short term.  Tight project deadlines, always additional work being added, etc.

I think that's part of the biggest selling point for SQL Dev: plugin capabilities.  If you can't find a plugin for what you need, it's possible to develop one.  Java of course.

Caveat: the selling point shouldn't be construed as a point Toad does not have.  Toad is vastly modifiable by the developer so I'd personally be hard-pressed to identify something you could make SQL Dev do that you couldn't make Toad do.

Roger S.

________________________________
This communication, including any attached documentation, is intended only for the person or entity to which it is addressed, and may contain confidential, personal and/or privileged information. Any unauthorized disclosure, copying, or taking action on the contents is strictly prohibited. If you have received this message in error, please contact us immediately so we may correct our records. Please then delete or destroy the original transmission and any subsequent reply.