SQL Developer Reviews & Product Details

Somewhat intuitive layout and the ability to store and easily access multiple different connections that have been previously setup easily and fast. Review collected by and hosted on G2.com.

Overall it's a clunky and often slow interface. There's no way to really get into the tables to edit data without right clicking on the table name IF it's in a select statement and going to "Open Declaration". It also handles unexpected disconnects poorly. The "Reconnect" menu item does not always work when the database has been unexpectedly disconnected and when it does work it sits for several seconds (maybe closer to 10) before it seems to realize the connection was already dropped and then it finally reconnects. Also, I believe it's when you disconnect then reconnect that it opens a new SQL window instead of allowing you to automatically start executing SQLs in the one you previously had open. You can use that window that was previously open, but you need to point it at the connection again. The execution plan is also not very intuitive. SQL Server Management Studio was designed much better. Toad, I hear, is a good replacement for SQL Developer. Review collected by and hosted on G2.com.

Access to any number of Oracle databases Review collected by and hosted on G2.com.

It is always necessary to restart the application since it uses to lose the active connection Review collected by and hosted on G2.com.

Easy to use. With this program you are up and running in no time. I love the feature that lets you store queries so you can pull them up later and run again. Review collected by and hosted on G2.com.

It seems inconvenient that you need to use another program to connect to the database before you can run SQL Developer. If I lose connection and the other program has to be reconnected, then SQL Developer will sometimes freeze. Then I'll have to restart and lose whatever query I am in the middle of building. Review collected by and hosted on G2.com.

This SQL interface is used in many different companies so it has coverage. The syntax is clear and similar to other SQL interfaces. Review collected by and hosted on G2.com.

This UI is not user friendly and seems to be bulky. It is hard to find tables easily. Poking around takes a lot of time to find what you need. Review collected by and hosted on G2.com.

The easiness of using SQL developer is awesome. Its really comfortable to use. Review collected by and hosted on G2.com.

managing with mulitple connections sometimes founds a bit of problem with opening multiple tables and viewing data is from different connections is bit slow. Review collected by and hosted on G2.com.

The best thing is that SQL Developer is free (comes with Oracle installation), and also uses native libraries.

Obviously, if you are using Oracle DBS, you will not have any connection problems.

It's very easy to install, and it has a very good support Review collected by and hosted on G2.com.

There are much much better options in the market, specially TOAD and PLSQL Developer, but, they are not free.

SQL developer is slow, very slow, and believe it or not, it has a lot of bugs.

Also the interface is not very friendly. Review collected by and hosted on G2.com.

I am currently using PL/SQL developer at my place of employment. Its a very easy tool to analyze data and perform arithmetic operations on data. The UI is simple and makes it easy to type large codes. Querying data is really fast. Review collected by and hosted on G2.com.

The PL/SQL developer lacks certain features like data import. If you need to import data from an external object you would need additional tools like access. Also moving around schema can get sometimes get tough. Timestamp fields are also difficult to view. You either need to see empty timestamp like 00:00 if the original column did not have time element or if you alter the NLS you cannot see the time element even if the column had time data. Review collected by and hosted on G2.com.

I use sql developer to go look up oracle information directly from the backend tables rather than going through oracle forms. Save so much time once you learn the table structures. The tool can also help you build some simple scripts/reports. Ability to view the code behind custom oracle views they have behind the forms. Review collected by and hosted on G2.com.

In my experience, browsing through the objects/fields by expanding/collapsing is very slow. Also exporting large result sets in excel format sometimes crashed. Review collected by and hosted on G2.com.

Written in Java (I think), it can interface pretty much with any database that has a JDBC connector. You might have to tell it where the appropriate jar is, but that's not too difficult. Navigating tables, views, etc is pretty easy, much like navigating a file system. Review collected by and hosted on G2.com.

If a query is taking a long time, SQL developer will freeze. Review collected by and hosted on G2.com.

This application is very easy to use. You can add many connections and browse different schemas easily. The SQL completion works very well and it has additional features like database comparison or database copying. Review collected by and hosted on G2.com.

The application has some performance issues, if you keep the application open but idle for some time it becomes unresponsive (at least the linux version). Review collected by and hosted on G2.com.