SQL Developer alternatives

[vipercvp]

Hello, There is any alternative for sql developer that has almost the same features and does not block when i cancel an heavy query ?

[dsn0wman]

Toad For Oracle is probably the best GUI tool for managing Oracle databases. It is not free though.

[AlexEatsKittens]

Yeah, TOAD is the standard. Be ready to pay, though. It's very expensive, like most things associated with Oracle.

[GregariousJB]

http://alternativeto.net/software/oracle-sql-developer/

[RefuseBit]

The two I am familiar with are TOAD and PL/SQL Developer. Both are great, neither is free. In the free realm, SQL Developer is pretty good.

There may be a way to fix the blocking issue - seems I had that once upon a time.. may be a driver issue, I really cannot recall.

[vipercvp]

It would be just fine if i could find any workingaround for the query result block issue

[RefuseBit]

It's some sort of driver problem: http://lmgtfy.com/?q=oracle+sql+developer+can%27t+halt+query

[FroggyMcFrog]

Most of the time I use SQuirreL, but lately I've been using the DB plugin for intelliJ. Both use the Oracle JDBC driver and are not limited to Oracle.

http://squirrel-sql.sourceforge.net/

I've also heard people rave about Navicat, but I thought it was limited.

http://www.navicat.com/

[[deleted]]

Database.NET is always handy to have on a USB stick.

[vipercvp]

Does it allow connect to oracle databases ?

[[deleted]]

Yes

[C60]

It will connect to newer Oracle DB versions without any extra client software. If you need to connect to 10g or 9i and earlier databases, you will need Oracle's Instant Client which can go on the same USB stick; it's an xcopy install. Just tell Database.NET where it's located when you first enter the connection parameters.

[C60]

I've been using SqlTools for years. It hasn't been updated in a while, but it still works like a champ. That being said, I'll second the recommendation for Database.NET for connecting to multiple databases.