views:

61

answers:

5

I'm used to the comfort of working with MSSQL and the Enterprise Manager and Query Analyzer. Now working with Oracle 9.2 and having to suffer using SQL Plus for making queries, I'm looking for some better alternatives. Are there any free or low-cost tools for this purpose?

+1  A: 

Try Toad: http://www.toadsoft.com/toad%5Foracle.htm

digitalsanctum
+4  A: 

SQL Developer

Free, Oracle supported, nice UI, type ahead syntatic help, schema comparison, script generation, data import / export, etc etc.

serg10
For MSSQL converts, especially - go to Tools, Preferences, Database, NLS Parameters, and set your date format to be yyyy-mm-dd hh24:mi:ssOtherwise, you are going to be very frustrated with the default date format.
ericp
I just downloaded and installed it, looks very promising
simon
+1  A: 

toad is the tool you're looking for. you can acquire it here : http://www.toadsoft.com/

Numenor
A: 

Using SQL Developer yopu can connect to your SQL Server database. http://www.oracle.com/technology/oramag/oracle/08-may/o38sql.html

Robert Merkwürdigeliebe
A: 

Try Devart's OraDeveloper Studio, a powerful development environment for working with Oracle, that has built-in visual query builder and supports Oracle versions from 7.3 to 11g.

Retail price is only $99.95 per license.

Devart