Oracle SQL tools

[vash]

Anyone have any links to some good SQL tools for Oracle? I know of TOAD, but are there any others (preferably free) other than the great SQL Plus? Also, any tools that work on linux would be great as well. I come from a MS environment and MS' Query Analyzer was quite good and would like a similar for Oracle.

Any links would be great!

vash

 

[glugglug]

other than the great SQL Plus?

ROFL.

TOAD is awesome, in many ways better than MS QUery Analyzer & MS Enterprise Manager.

BTW, Oracle comes with an "Enterprise Manager" which is a java app, but it's extremely buggy and even if it was bug-free it would pale in comparison to the MS tools you are used to. It's really amazing just how crappy the tools that come with the most popular DBMS system can be.

Have you used up your 30 day trial of TOAD yet? BTW, it's not hard to guess at working keys....

I don't know what else you would use. Yeah, the 800+ per seat for Toad license is a lot, but seeing as your company apparently already has the money for Oracle, it's worth it.

 

[Mitzi]

I use TOAD at work, just upgraded to the latest 7.5 release so I'm going to have a play later and see whats changed.

Whilst TOAD is expensive, it will quickly and easily pay for itself in productivity gains alone and lets be honest if you can afford Oracle you can afford the tools

 

[vash]

Thanks for the responses. It seems that everyone likes TOAD. Has anyone used SQL Navigator (also from Quest)?

Any other tools out there?

vash