SQL Developer Reviews & Product Details

It takes Less time to Manipulation of Data.

Simple Interface of Data Review collected by and hosted on G2.com.

It is very difficult to remember too many queries and commands Review collected by and hosted on G2.com.

1. SQLDeveloper is a user-friendly tool for writing and executing queries.

2. Monitoring of sessions and executed SQLs becomes easy.

3. Create and Maintain connections.

4. Access all Database objects which are in the grant. Review collected by and hosted on G2.com.

Sometimes, the heavy load on the system and database when executing big data objects like procedures makes it get into hang mode, making it difficult for the user to debug/analyze the execution process after forcefully closing it. Review collected by and hosted on G2.com.

SQL Developer is very flexible tool for accessing the data, and to manipulate the data. Review collected by and hosted on G2.com.

UI needs to be improved, so that it looks more attractive. Review collected by and hosted on G2.com.

It's easy to debug the packages written by Plsql code, and also it allows to control of the oracle database in configurations + monitoring using $ tables. Review collected by and hosted on G2.com.

Eventually, the debugger might hang while debugging the packages if the package has thousands of lines. However, it can be done using the debug points rather than going through the line by line in the code. Review collected by and hosted on G2.com.

Easy to monitor the performance of PLSQL codes and analysis the time and get the profiler report to understand which code part takes much time to complete. And it will allow checking the explain plan for the specific SQL query. Review collected by and hosted on G2.com.

when I ran the profiler report for a test code the application went 'Not Responding’ most of the times. However, it returns to live once the report completed. Review collected by and hosted on G2.com.

As my primary skill was Oracle SQL, PLSQL, I mainly used SQL developer for Oracle data retrieval, insertion, and updation work. Now-a days just data retrieval is not useful, so performance tuning is playing a key role in any company and this tool has an inbuilt feature of explain plan which I mostly used for query tuning. Review collected by and hosted on G2.com.

The downside of SQL developer is that when you export data into any file with a million rows, it takes longer to export and sometimes hangs. Another thing is that if an export operation is going on and you want to cancel that activity, this tool is not that user-friendly. Review collected by and hosted on G2.com.

1. Fetching and extracting of data is very easy.

2. User interface is also very good

3. It comes at very cheap price as compared to other product present in market Review collected by and hosted on G2.com.

1. Sometimes managing large data become hectic

2. Proper documentation for accessing the features over internet is limited

3. Sometimes not able to get solution for ORA errors happening for statement Review collected by and hosted on G2.com.

This tool is best to perform the database operations like DDL , DML, DCL on oracle database. I saw the performance is very good and it's an user friendly tool which always gives satisfaction to users. Making connect is very easy and using this tool for data analysis is always gives quick insights out of the data. Review collected by and hosted on G2.com.

It sometimes hang if we handled large anount of data or any complex sql procedures.

Interface of this tool is good but can be improved further.

Queries inspection could be better like toad so that user can do deep data analysis using this took. Review collected by and hosted on G2.com.

* It helps us to manage the database efficiently

* Easy to access and auto suggestions are good

* We can get all previously used scripts and we can manage large data Review collected by and hosted on G2.com.

* Sometimes Hanging if not used more than 5 mins

* Date columns are not prompting time by default

*Sometimes it uses more RAM than expected Review collected by and hosted on G2.com.

To summarize, the most likable features of Oracle SQL Developer :

1. Clear, crisp, and concise UI. Minimalist UI makes SQL developer a beginner's friendly IDE for SQL and PL/SQL developers.

2. Connection manager enables the user to manage, create and delete database connections.

3. The connections are portable in XML or JSON format. And to export and share the database connections, we need not share the connection password, and we can encrypt the connection files with an encryption password.

4. Multi-tab query feature. In a SQL developer, we can open multiple tabs (SQL worksheets), we can develop multiple queries at the same time.

5. Supports Oracle NoSQL connections.

6. Easy to debug code with the "Message Log" feature.

7. Open source and available for free. Just one needs to create a free oracle account, all of which is free of any cost, and no Credit card is required.

8. Best IDE to write PL/SQL code blocks, although Oracle has a PL/SQL developer, developers prefer SQL developer to write / developer / manage PLSQL code blocks (Package/Procedure/Functions). Review collected by and hosted on G2.com.

There are a few points, which I would like Oracle to improve about the SQL developer, those are :

1. The Software is resource-intensive. I have seen machines with less than 4 GB of Ram struggle to run this software.

2. There is a limitation in the view of the result set. When a user drags down to scroll through the entire result set, it freezes after 20-30 rows of the result set.

3. If a connection is left unused for more than 10 minutes, the connection drops, and it resets, the transaction session is dropped.

4. With VPNs, SQL developer frequently drops the connection. Review collected by and hosted on G2.com.