SQL Developer Reviews & Product Details

Things that I like the most about Oracle SQL Developer:

-Using this, we can create and maintain numerous databases and tables with just a few steps.

-The User Interface is straightforward; therefore, It will take no time to learn.

-It comes with some default tables, which will be helpful for beginners as a quick start to execute queries.

-You can connect to other applications/software easily and quickly.

-And, of course, It's free to use. Review collected by and hosted on G2.com.

-The configurations you need to do might seem overwhelming initially, but it will get easier with time.

-Sometimes, the app freezes on my laptop.

-Autosave is unavailable, so you have to save your queries manually(Don't worry, the tables will be there even if you don't save them). Review collected by and hosted on G2.com.

It's amazing. It solve your tideous task into simpler one. Easy to integrate and manage. Review collected by and hosted on G2.com.

No dislikes founds yet. It's amazing to write your SQL query. Review collected by and hosted on G2.com.

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.