SQL Developer Reviews & Product Details

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

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.

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.

We can exported data in various file format simply. Best performance. Database components easily modify/dropped. Multiple database can connect easily Review collected by and hosted on G2.com.

Automatically disconnected when network slow. Review collected by and hosted on G2.com.

Easy user interface is probably makes it one of the best available tool in market, specially for beginners also it's very easy to learn and write code in SQL developer. Review collected by and hosted on G2.com.

Sometimes it disconnected automatically while the connection is slow. Also faced issues while extracting a large data, suppose if connection drops while extracting a large amount of data then we need to take the extract again from starting. Review collected by and hosted on G2.com.

Build and analyze SQL queries by connecting multiple databases from one tool.

Import data easily from text files, Excel files, and CSV files..etc

Easy to install and configure.

User-friendly GUI and easy to navigate through various features easily. Review collected by and hosted on G2.com.

It uses a lot of desktop/laptop memory.

Lack of scheduling jobs and needs to improve

Export or import data from on-prem to cloud easily

Nice to have a drag and drop feature. Review collected by and hosted on G2.com.

It is a graphical version of sql plus ,it is easy to connect different databases and different schemas ,easy to connect MySQL and other databases using the relevant drivers.

Easy to see the result set and also to export as a file. Review collected by and hosted on G2.com.

It is taking more time in first time setup as we need to give correct path of java installed in your system.

Sometimes it's taking more time to open the application itself. Review collected by and hosted on G2.com.