SQL Developer Reviews & Product Details

1. Lightweight Application, doesn't take much time to start.

2. Many people think that oracle SQL Developer GUI is a bit old, but I personally feel that its easy to understand and work with.

3. SQL Developer tool automatically recognizes the syntax tags and highlights them in different color which provides good understandable representative look. As well as it always prompts the syntax/table/column names while typing any query.

4. As it's easy to know how many rows and tables will be affected after performing certain operations on database, it makes a good tool for both development and testing purpose.

5. By the help of this tool, you can import or export the data very easily. Review collected by and hosted on G2.com.

1. Oracle SQLDeveloper Tool doesn't automatically reset connection. If you've half done your work today and tomorrow you want to continue the same then you have to again choose the connection or continuously refresh it else it'll give error message.

2. If you don't know the status of query and if query is taking too much time to respond, it shows the status as RUNNING whereas in reality the query may have hung up. It should provide clear message of query status whether it's running or stuck in between. And this happens many times with me.

3. You can't simultaneously run multiple queries of a single database connection. You have to wait for successful execution of first query, then only it'll move ahead to execute next query in the line.

4. Instead of showing only the error at line, more simplified message should be provided to address the error. Review collected by and hosted on G2.com.

The tool has so many things to offer and easy to use Review collected by and hosted on G2.com.

It's user interface can be improved. It still looks like it was built in the 1990s Review collected by and hosted on G2.com.

IntelliSense, highlight errors, provide autosuggestions Review collected by and hosted on G2.com.

It does not notify that the WHERE clause is missing in the UPDATE command. Review collected by and hosted on G2.com.

I like the layout of the application, buttons, menus on my first use it was not difficult to find me. The shortcuts I use a lot, have a lot of customization tools and have added a lot to me. Review collected by and hosted on G2.com.

I had a problem with a table with Clob of the system (passes up to 8 thousand characters) sometimes in the select it hangs even bringing less data. I even did a test that ran only the developer and passed, so I believe it is something from my memory, but I could have some feedback from this freeze. I already did a test and left the application open and 1 hour went by without response. Review collected by and hosted on G2.com.

The best part of this is that you can write complex queries and fetch data according to your needs. Stored a large amount of data according to your industrial needs. Review collected by and hosted on G2.com.

The only problem that I have seen in this there performance. When there is vast amount of data stored table, then the performance of fetching data decreases. Review collected by and hosted on G2.com.

It is very simple to use and intuitive. It also has a clear structure, so anyone who works in SQL Developer has a complete picture of the database objects. One of the best parts of SQL Developers is snippets. It is a very practical way to have parts of the code at hand. Review collected by and hosted on G2.com.

There is no multi-filter function (creating multiple filters and applying when you want). Review collected by and hosted on G2.com.

Ease of use. It's excellent software. Very easy to use and can customize as we want. Review collected by and hosted on G2.com.

Sometimes glitches. It can get stuck, and then you have to restart. Review collected by and hosted on G2.com.

Capability to debug the queries, stored procedures easily, tools for writing the queries like highlighting the queries syntax and auto format of code. Review collected by and hosted on G2.com.

This product does not have any particular dislikes Review collected by and hosted on G2.com.

As a developer, this was the best tool for building custom applications Review collected by and hosted on G2.com.

Version changes and integration was a little tricky Review collected by and hosted on G2.com.

The best thing I like about Oracle SQL Developer is its user interface. It has an easy-to-use platform including its navigation to different features, connectivity to different local environments. Also, different schemas can be handled with ease. Also, the installation process is pretty simple. Review collected by and hosted on G2.com.

I have not found any cons as of now. It gets me all the basic work done. The only point can be its heaviness as it consumes more RAM. Review collected by and hosted on G2.com.