SQL Developer Reviews & Product Details - Page 9

What do you like best about SQL Developer?

What a tool like SQL Developer needs to do, it does... I'm used to TOAD and Microsoft SQL Server Management Studio, and SQL Developer in a lot of aspects outperforms these products. It's clean and highly intuitive, no learning curve required whatsoever. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

If you really push me to mention something negative, then I have to mention the fact that you can't easily navigate from and within stored procedures or any other object. Within TOAD you can very easily do this through shortcuts. Just write down the name of a stored procedure, and you can right click it, or use a shortcut to immediately go there. In SQL Developer I find myself too often scrolling to the stored procedure. I know... it's only a small discomfort. I'm not a power user (not a dba or stored procedure developer). I use this tool only for querying and looking up (and ORDS design). From what I hear from the "real" power users, they all prefer TOAD for the beforementioned reason. Review collected by and hosted on G2.com.

What do you like best about SQL Developer?

SQL Developer, is available on multiple platforms, Windows Mac Linux and Oracle doesn't charges a penny for it. So, SQL Developer is best suited for a big cross functional globally based team. SQL Developer is less resource intensive, compared to other IDEs. SQL Developer has the capability to manage and develop Oracle Database in both on premise and Cloud deployments. SQL Developer can also connect and interact with non oracle database like IBM db2,MS Sql server and MySQL etc. Its installation package is available in two formats, one is normal exe and other portable zip compressed file. And it gives session management console, which is lacking in many other competitor's product. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

The output window shows very less number of data records at a time, and scrolling with mouse in the output screen, makes the SQL Developer freeze and it starts struggling. SQL Developer at times, consumes too much of memory and RAM. Ideally a machine should have at least 8 Gb of Ram. Connections import and export is bit tricky, older versions supported xml and new versions support json. So updating the SQL Developer may be a bit clumsy if you overlook this fact. Review collected by and hosted on G2.com.

What do you like best about SQL Developer?

User Friendly, Easy to write complex queries, fast search, and retrieval of results Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

Extracting the retrieved data to an excel or CSV takes a long time. If you have any project that needs to pull a lot of data in excel, this tool is not advisable. Review collected by and hosted on G2.com.

What do you like best about SQL Developer?

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.

What do you dislike about SQL Developer?

1.Oracle SQLDeveloper Tool doesn't automatically resets 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.

What do you like best about SQL Developer?

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

What do you dislike about SQL Developer?

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.

What do you like best about SQL Developer?

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

What do you dislike about SQL Developer?

it does not notify that where clause is missing on update command Review collected by and hosted on G2.com.

What do you like best about SQL Developer?

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.

What do you dislike about SQL Developer?

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.

What do you like best about SQL Developer?

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.

What do you dislike about SQL Developer?

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.

What do you like best about SQL Developer?

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.

What do you dislike about SQL Developer?

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

What do you like best about SQL Developer?

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.

What do you dislike about SQL Developer?

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