SQL Developer Reviews & Product Details

It's easy to use. It's portable, no installation. Lastly, easy to handle with multiple instances. Review collected by and hosted on G2.com.

Sometimes instance expires automatically. Review collected by and hosted on G2.com.

The ease of use is the best part of SQL Developer. I haven't enjoyed this ease with other databases like MS SQL Server. E.g., the rollback feature is such a blessing! Review collected by and hosted on G2.com.

I can barely think of anything! Right now, I miss working with SQL Developer. Review collected by and hosted on G2.com.

Oracle is the largest company in relational databases and the tool of choice for operation, high-performance database workflows. We can be confident which specific efficiency and functionality requirements are fulfilled thanks to Oracle RDBMS's reliability, as well as increased & disaster recovery services like Oracle RAC or Data Guard. Oracle SQL Developer provides excellent performance efficiency, consistency, and security. Review collected by and hosted on G2.com.

Oracle SQL Developer has not caused any problems for us. Review collected by and hosted on G2.com.

SQL Developer is really an easy tool to work upon. The export-import of files is easy and supports all major file formats like Excel, CSV, and XML Review collected by and hosted on G2.com.

Sometimes the connection to the database lags. Review collected by and hosted on G2.com.

- Easy to install

- User-friendly UI

- Can import data from text, Excel, CSV file

- Easy debugging of the stored procedures

- Easily know table dependencies

- Error details and line number on failed execution of the query

- Can execute number of queries simultaneously

- Shows number of rows affected Review collected by and hosted on G2.com.

Automatically gets disconnected if it is in idle state. Review collected by and hosted on G2.com.

This is one of the most used tools in our organization we are mainly using it for creating tables and data sources. The user interface is amazing and it's very to understand and navigate. You can easily write a query and spool the data as per your requirement. Creating reports and dashboards are also very convenient and easy with SQL developers. Review collected by and hosted on G2.com.

There are some limitations like you cannot search more than 1000 records at a given time etc. But overall its the great tool. Review collected by and hosted on G2.com.

SQL Developer is the easiest and quickest way to see the data in the system. In addition to offering a complete and efficient service, it is free! Review collected by and hosted on G2.com.

The only negative point of SQL is the impossibility of implementing recursive processing. Review collected by and hosted on G2.com.

What a tool like SQL Developer needs to do, it does... I'm used to TOAD and Microsoft SQL Server Management Studio, and SQL Developer in a lot of aspects outperforms these products. It's clean and highly intuitive, no learning curve required whatsoever. Review collected by and hosted on G2.com.

If you really push me to mention something negative, then I have to mention the fact that you can't easily navigate from and within stored procedures or any other object. Within TOAD you can very easily do this through shortcuts. Just write down the name of a stored procedure, and you can right click it, or use a shortcut to immediately go there. In SQL Developer I find myself too often scrolling to the stored procedure. I know... it's only a small discomfort. I'm not a power user (not a dba or stored procedure developer). I use this tool only for querying and looking up (and ORDS design). From what I hear from the "real" power users, they all prefer TOAD for the beforementioned reason. Review collected by and hosted on G2.com.

SQL Developer, is available on multiple platforms, Windows Mac Linux and Oracle doesn't charges a penny for it. So, SQL Developer is best suited for a big cross functional globally based team. SQL Developer is less resource intensive, compared to other IDEs. SQL Developer has the capability to manage and develop Oracle Database in both on premise and Cloud deployments. SQL Developer can also connect and interact with non oracle database like IBM db2,MS Sql server and MySQL etc. Its installation package is available in two formats, one is normal exe and other portable zip compressed file. And it gives session management console, which is lacking in many other competitor's product. Review collected by and hosted on G2.com.

The output window shows very less number of data records at a time, and scrolling with mouse in the output screen, makes the SQL Developer freeze and it starts struggling. SQL Developer at times, consumes too much of memory and RAM. Ideally a machine should have at least 8 Gb of Ram. Connections import and export is bit tricky, older versions supported xml and new versions support json. So updating the SQL Developer may be a bit clumsy if you overlook this fact. Review collected by and hosted on G2.com.

User Friendly, Easy to write complex queries, fast search, and retrieval of results Review collected by and hosted on G2.com.

Extracting the retrieved data to an excel or CSV takes a long time. If you have any project that needs to pull a lot of data in excel, this tool is not advisable. Review collected by and hosted on G2.com.