SQL Developer Reviews & Product Details

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 becomes hectic

2. Proper documentation for accessing the features over the 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 a user-friendly tool which always gives satisfaction to users. Making connect is very easy and using this tool for data analysis always gives quick insights out of the data. Review collected by and hosted on G2.com.

It sometimes hangs if we handle a large amount of data or any complex SQL procedures. The interface of this tool is good but can be improved further. Queries inspection could be better like Toad so that users can do deep data analysis using this tool. 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.

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.

The constraint of language standardization restricts user functionality. The processing speed seems quite low. Review collected by and hosted on G2.com.

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

The stability is less when the query takes a long time to execute. When usage 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.

Well SQL Developer is good for beginners. They can easily run/ test queries with the simpler editor. Also, they can add, delete, and search, update manually from the schema browser window. It provides some handy features like Data Modeling. We just need to drag and drop our tables into windows it will automatically draw relations between tables. It also provides Export/ Import utilities. We can also connect as a DBA in the DBA window. Review collected by and hosted on G2.com.

The bad thing about SQL Developer is that it got disconnect after every 10 minutes if we don't use it. Which is very irritating. It does not have the searching facility for a specific object like Sequences, Triggers, Tables etc. I will not recommend this software for professional or senior developers. Review collected by and hosted on G2.com.

Its user interface is simple and convenient to learn and understand for a new user. Especially the drag-and-drop feature for the tables and relations makes things very convenient. Review collected by and hosted on G2.com.

Its frequent disconnection is problematic for me. If there is no activity for a certain time, the SQL Developer disconnects. It also takes a good amount of time to load. Review collected by and hosted on G2.com.

It helps in connecting to remote databases as well with ease. We can do all DB operations with ease and perfection. I have used it to connect to my Oracle Databases which are at remote locations Review collected by and hosted on G2.com.

The load time of the SQL Developer is too long which can be improved a lot to make it the best in the market Review collected by and hosted on G2.com.