SQL Developer Reviews & Product Details

- Easy to install

- User-friendly UI

- Can import data from text, Excel, CSV file

- Easy debugging of the stored procedures

- Easily know table dependencies

- Error details and line number on failed execution of the query

- Can execute number of queries simultaneously

- Shows number of rows affected Review collected by and hosted on G2.com.

Automatically gets disconnected if it is in idle state. Review collected by and hosted on G2.com.

This is one of the most used tools in our organization we are mainly using it for creating tables and data sources. The user interface is amazing and it's very to understand and navigate. You can easily write a query and spool the data as per your requirement. Creating reports and dashboards are also very convenient and easy with SQL developers. Review collected by and hosted on G2.com.

There are some limitations like you cannot search more than 1000 records at a given time etc. But overall its the great tool. Review collected by and hosted on G2.com.

SQL Developer is the easiest and quickest way to see the data in the system. In addition to offering a complete and efficient service, it is free! Review collected by and hosted on G2.com.

The only negative point of SQL is the impossibility of implementing recursive processing. Review collected by and hosted on G2.com.

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.

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.

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.

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.

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

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.

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 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.

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.