SQL Developer Reviews & Product Details - Page 6

What do you like best about SQL Developer?

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

What do you dislike about SQL Developer?

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

What do you like best about SQL Developer?

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.

What do you dislike about SQL Developer?

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.

What do you like best about SQL Developer?

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.

What do you dislike about SQL Developer?

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.

What do you like best about SQL Developer?

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.

What do you dislike about SQL Developer?

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.

What do you like best about SQL Developer?

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.

What do you dislike about SQL Developer?

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.

What do you like best about SQL Developer?

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.

What do you dislike about SQL Developer?

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.

What do you like best about SQL Developer?

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

What do you dislike about SQL Developer?

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

What do you like best about SQL Developer?

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.

What do you dislike about SQL Developer?

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.

What do you like best about SQL Developer?

It is easy to retrieve and data extraction from SQL.

Customization and Manipulation can be done without any interruption.

Accessible and user-friendly interface Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

The constraint of language standardization restricts user functionality.

The processing speed seems quite low. Review collected by and hosted on G2.com.

What do you like best about SQL Developer?

Sql developer has the ability to browse across the datsbase components and easily modify or drop them or even create new ones. Debugging is also easy incase of issues. Review collected by and hosted on G2.com.

What do you dislike about SQL Developer?

The stability is less when the query takes a long time to execute. When ussge is heavy then it lags a lot. Reconnect takes a long time when the database has been disconnected unexpectedly. Review collected by and hosted on G2.com.