SQL Developer

(68)
4.0 out of 5 stars

Oracle database management tool

Work for SQL Developer?

Learning about SQL Developer?

We can help you find the solution that fits you best.

Find the Right Product

SQL Developer Reviews

Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • Industry
Ratings
Company Size
User Role
Industry
Showing 73 SQL Developer reviews
LinkedIn Connections
SQL Developer review by Gustavo A.
Gustavo A.
Validated Reviewer
Verified Current User
Review Source

"Useful tool for basic SQL"

What do you like best?

SQL Developer is very useful to organize different connections (Oracle databases). It's easy to use, intuitive and clean design. It has plenty plugin users.

It's free.

In terms of SQL developing it's a tool that offers the developer everything needed.

What do you dislike?

Quite slow and not so useful if you are not using an Oracle Database.

If you want to edit a table the process is not so quick as it should.

It has to improve some export tools (Excel tables, e-mail connection).

Recommendations to others considering the product

If you are starting with SQL, SQL Developer is good starting point.

If you are using for professional purposes, more advanced level, the tool gives a lot and almost everything needed and it's free.

What business problems are you solving with the product? What benefits have you realized?

To develop the application I am working on at the moment, I need to get information and cross it with different databases. SQL does the job.

I also use it to Data management of different applications.

Sign in to G2 Crowd to see what your connections have to say about SQL Developer
SQL Developer review by Prashant S.
Prashant S.
Validated Reviewer
Verified Current User
Review Source

"Great tool to execute SQL on any database"

What do you like best?

It has a good interface and also we can get list of all SQL executed in history section.

It has explain plan which is of great help.

Also now we can manually specify the TNS file path which is of great help to developers.

In recent release its ability to connect to cloud dB.

What do you dislike?

The result which we get after executed should be saved in a csv. It get lost if we run another query.

We should have history of result set.

Also it should have excel like feature to sort and filter result set.

Recommendations to others considering the product

Its easy to install

Easy to use

has SQL Explain so you can check the performance of your SQL.

What business problems are you solving with the product? What benefits have you realized?

It help us to query database and generate reports which is shared to client.

What Non-Native Database Management Systems solution do you use?

Thanks for letting us know!
SQL Developer review by Stanley J.
Stanley J.
Validated Reviewer
Verified Current User
Review Source

"SQL Developer is a good option for keeping up with multiple Oracle Databases."

What do you like best?

I like that I can quickly organize multiple connections and get to them with a simple double click. The Auto-fill for packages, procedures, and functions helps write queries quicker with such a large code base. The sort and filter options in the results is also a great feature.

What do you dislike?

I would like the ability to drag column headers into queries from the results section. That is one function I believe would make the product better. SQL Dev also tends to be a bit resource hungry and can take a good bit of time to load on occasion.

Recommendations to others considering the product

There are a lot of other products out there for managing and querying databases. This works particularly well for us, as we also primarily use Oracle Databases. Take a look at the nice integration with other Oracle systems, as I believe that's where this product truly shines.

What business problems are you solving with the product? What benefits have you realized?

I use SQL developer to query my data warehouse and other data sources I have access to. I use these queries to define data sets for use in analytics and also do auditing between data sources.

SQL Developer review by Margiorie M.
Margiorie M.
Validated Reviewer
Review Source

" Easy to use and reliable"

What do you like best?

It is an easy tool to use to perform the development of the different database components that are required, the component scanner is ideal for locating them. I always use it to program, debug and execute in a single environment what is needed. It allows me to efficiently and quickly manage users, permissions and profiles.

What do you dislike?

In general I like to work with SQl developer, I think it should only improve the generation of DDL and database documentation

Recommendations to others considering the product

I highly recommend it, since it is really very easy to use and reliable, it does not present problems when developing the different components that are required for the database.

What business problems are you solving with the product? What benefits have you realized?

With this tool I generate the components (Stored procedure, Types, Tables, etc) that are needed for the integration of BPM processes (Generate commercial credits, Credit cards, etc) with Soap services. It helps me resolve queries and updates from the front to the different Backend

SQL Developer review by Anthony J.
Anthony J.
Validated Reviewer
Verified Current User
Review Source

"Good IDE for PL SQL"

What do you like best?

It allows you to save multiple database connections which comes in handy. The UI is clean and neat. You can use multiple filters on database objects.

What do you dislike?

SQL Developer doesn't have a built-in "profiler" that allows administrators to "see" what's happening in the server. Even 3rd party profilers doesn't give you as much detail like it's competitor, MS SQL.

Recommendations to others considering the product

Give it a try. Develop in parallel with your current database. It requires quite a stiff learning curve.

What business problems are you solving with the product? What benefits have you realized?

Cost. Some of our clients are migrating to Oracle because it's less expensive than MS SQL. But be very aware of the pros and cons. Have a thought about it.

SQL Developer review by John T.
John T.
Validated Reviewer
Verified Current User
Review Source

"Useful for using Oracle, make sure your JAVA is in order."

What do you like best?

It connects up to all of our Oracle databases, and it has a native client for every platform.

What do you dislike?

I hate that by default it only loads 50 rows at a time. Also some bits are not very intuitive, or force the query to run a second time, for example trying to export data that was already displayed on your screen. This can be an extra pain for long queries.

Recommendations to others considering the product

Make sure you have the latest JRE and JDK installed prior to installing it. If you only want to run one database tool, it does support plugins to allow you to connect to other data sources. I don't find it as intuitive as some other clients, but its common usage means there is a lot of documentation out on the web.

What business problems are you solving with the product? What benefits have you realized?

Troubleshooting database information within technical support. It works well and helps us find and analyze things.

SQL Developer review by Consultant in Information Technology and Services
Consultant in Information Technology and Services
Validated Reviewer
Verified Current User
Review Source

"Comparison of Oracle SQL Developer with some other same products in the market"

What do you like best?

Saved Credential for users, Imp/Exp, GUI

What do you dislike?

Its Slow, it Don't Remember my Condition

Recommendations to others considering the product

It is a good tools to play with data, but it is not very good in speed, The most painful is not keeping your where conditions saved to apply on other tables, rather you will have to write where condition again even you want to use the same where condition for other tables. Imp and exp command are not available for database. Other features are as good as in the other such products, like SQL Server , etc.

What business problems are you solving with the product? What benefits have you realized?

1. As a developer I user it for Checking my data whether every column is updating correctly as per my code, 2. When users make mistakes I quickly fetch that data using it. 3. Create tables and Indexes for my projects. 4. Write Procedures. 5. Copy my sql command that I use in my programs and run in here to check for the syntax or other errors. 6. Show my clients users the data from here to proof many things like whether the data is updating correctly and that they have made mistakes in entries. etc. 7. In Short I must keep my SQL Developer window opened while writing database applications so that I can quickly check the reflections.

SQL Developer review by Vipul J.
Vipul J.
Validated Reviewer
Verified Current User
Review Source

"Good Tool. Does the Job. Prefer PLSQL Developer "

What do you like best?

Has a nice export query result functionality which supports exporting results to csv, xls, as well as a loader script. Easy to use UI. Provides nice to have interface for accessing DBA objects if you have DBA privileges. Has easy integration with version control tools such as GIT and SVN.

What do you dislike?

Not so stable and lags if the query is taking a long time to execute. Hangs if query execution is stopped before completion of a time-consuming query. Cannot keep the application window open for a longer time as the application will stop responding and you will have to restart the application.

Recommendations to others considering the product

Free and comes with oracle installation. Has almost all the features which a Developer would need. Not fancy though. If you have a choice, go for Toad or PLSQL Developer.

What business problems are you solving with the product? What benefits have you realized?

As I am worked in the Financial Domain, most of the business logic resides in the backend. Creating MIS daily and quarterly reports for a major financial institution is the main business goal for our project. SQL Developer has inbuilt features which help in performance tuning of the application. Provides explain plan window as well other query analyser features which are useful for performance tuning of the queries.

SQL Developer review by Jared K.
Jared K.
Validated Reviewer
Verified Current User
Review Source

"Does the job, but not too well"

What do you like best?

Somewhat intuitive layout and the ability to store and easily access multiple different connections that have been previously setup easily and fast.

What do you dislike?

Overall it's a clunky and often slow interface. There's no way to really get into the tables to edit data without right clicking on the table name IF it's in a select statement and going to "Open Declaration". It also handles unexpected disconnects poorly. The "Reconnect" menu item does not always work when the database has been unexpectedly disconnected and when it does work it sits for several seconds (maybe closer to 10) before it seems to realize the connection was already dropped and then it finally reconnects. Also, I believe it's when you disconnect then reconnect that it opens a new SQL window instead of allowing you to automatically start executing SQLs in the one you previously had open. You can use that window that was previously open, but you need to point it at the connection again. The execution plan is also not very intuitive. SQL Server Management Studio was designed much better. Toad, I hear, is a good replacement for SQL Developer.

Recommendations to others considering the product

Use Toad instead. I have not used Toad myself, but many I work with use it and when I am working with them they seem to navigate it easily and they also all prefer it to SQL Developer. I really need to jump on the Toad bandwagon in my office.

What business problems are you solving with the product? What benefits have you realized?

Maintaining a database for a CIS application.

SQL Developer review by Isa D.
Isa D.
Validated Reviewer
Verified Current User
Review Source

"Good basic program"

What do you like best?

Easy to use. With this program you are up and running in no time. I love the feature that lets you store queries so you can pull them up later and run again.

What do you dislike?

It seems inconvenient that you need to use another program to connect to the database before you can run SQL Developer. If I lose connection and the other program has to be reconnected, then SQL Developer will sometimes freeze. Then I'll have to restart and lose whatever query I am in the middle of building.

Recommendations to others considering the product

SQL Developer will get you up and running fairly quickly. Good interface for writing queries that can be stored for later use. Works well with Oracle.

What business problems are you solving with the product? What benefits have you realized?

I mainly use SQL Developer to query data from PowerSchool. When multiple tables are involved, pulling data is often easier and/or quicker with SQL Developer than with PowerSchool's build-in features.

SQL Developer review by Administrator in Oil & Energy
Administrator in Oil & Energy
Validated Reviewer
Verified Current User
Review Source

"Sql developer does not function well"

What do you like best?

Its makes some of the ugly oracle issues go away, it has a good ui for the most part

What do you dislike?

Alot. F9 vs f5 for starters. Reconnect option never works and software give no feedback. Many of ghe options aren't where they should be, crashes far far more frequntly than it should, consumes a hige memory footprint, will often times not let user cancel sn action, the sproc interface is garbage, for starters.

Recommendations to others considering the product

If you have to edit an oracle db, Stick with toad, Its lighter weight and easier to use, and it doesn't crash.

What business problems are you solving with the product? What benefits have you realized?

Connecting to oracle instancd for basic crud type operations. Mostly in support oc client dba staff of to supporf our own software products. Thd only benefit id that we didnt pay for it

SQL Developer review by Laura G.
Laura G.
Validated Reviewer
Review Source

"Great IDE for sql "

What do you like best?

It helps you organize different connections and even you can divide it with folders. It's fas and easy to use, very intuitive. You can filter your information and even the name of the tables, I like the function very much.

What do you dislike?

It's only useful if you use an oracle database. It might be a little slow if your script it's veeeeery long. Sometimes you have to adapt the query to oracle based sql.

Recommendations to others considering the product

Great option to organize your database if you use an oracle one.

What business problems are you solving with the product? What benefits have you realized?

At work, we use it to connect with different databases based on oracle. It's easy to use. We use it to consult data of our applications.

SQL Developer review by Chirag A.
Chirag A.
Validated Reviewer
Review Source

"Great Software for writing SQL"

What do you like best?

It is having very good Graphical User Interface along with a nice object explore. Also one can see all the transaction related statistics without even writing the command.

What do you dislike?

It is bit heavy and sometimes took time while reconnecting or restarting.

Recommendations to others considering the product

Sql developer is a great tool for writing SQL statements and creating PL/Sql stored procedures. I highly recommend this product due to its great graphical user interface and the auto suggestions.

What business problems are you solving with the product? What benefits have you realized?

We have a project in which we are doing application development and if user report any issue then we need to analyze the data where we need to use SQL developer.

Also it is best suitable for Oracle DB and analyzing any data become easier via this tool.

SQL Developer review by Sean S.
Sean S.
Validated Reviewer
Verified Current User
Review Source

"A decent basic SQL editor"

What do you like best?

SQL Developer is a simple interface for basic coding and it has a robust set of customizations available, as well as integration with version control tools like git and SVN.

What do you dislike?

As a OS X user, I find that there are a fair number of features that just don't work, or only work with extensive manual modifications to the code base. I'd prefer a tool that worked reliably out of the box.

For example, if you want to use the "Reset password" feature you have to install the separate Instant Client, then go in and edit the launcher tool to set paths correctly for Darwin. Simply put, if the tool is available for a popular OS, features should be tested and working or made unavailable until they are.

Recommendations to others considering the product

It may be worthwhile to evaluate alternative tools if you're looking for something to do more than basic database queries.

What business problems are you solving with the product? What benefits have you realized?

Sometimes a GUI is nice. We have a lot of non-database developers that use SQL*Developer as a means of connecting easily with the database, which simplifies their lives.

SQL Developer review by Robby T.
Robby T.
Validated Reviewer
Verified Current User
Review Source

"Great Data Extraction for Non-Profit Database"

What do you like best?

This software enables me to easily connect to my database and extract the specific information I need. I am able to join many different table and query based on many different criteria. The software program allows me to use long lists of criteria entries as well. It is intuitive, well organized and and fast.

What do you dislike?

The password interface to connect to different database instances could use some work to be more intuitive and easier to change or lookup forgotten passwords.

What business problems are you solving with the product? What benefits have you realized?

I am tasked with extracting specific data to be analyzed. The benefits of SQL developer include fast extraction of data, helpful troubleshooting, searchable queries and scripts, script key work highlighting and fast query building.

SQL Developer review by Suhasini B.
Suhasini B.
Validated Reviewer
Verified Current User
Review Source

"My experience with SQL Developer"

What do you like best?

The best thing about SQL Developer is one of the best IDE. It has variety of plugins, includes easy design. It connects to all oracle database.

What do you dislike?

It becomes slow and hangs for a longer period of time. It doesn't load when big output needs to be delivered.

Recommendations to others considering the product

Works well with oracle database, good for beginners.

What business problems are you solving with the product? What benefits have you realized?

It is very helpful for the beginners as there is not much complications involved while using application.

SQL Developer review by User in Education Management
User in Education Management
Validated Reviewer
Verified Current User
Review Source

"Not as user friendly as MS SQL"

What do you like best?

This SQL interface is used in many different companies so it has coverage. The syntax is clear and similar to other SQL interfaces.

What do you dislike?

This UI is not user friendly and seems to be bulky. It is hard to find tables easily. Poking around takes a lot of time to find what you need.

Recommendations to others considering the product

SQL Developer is a bit clunky and not intuitive. There are many how-to's online that can help a user with this software. There are other SQL interfaces that are more intuitive for non-dev and non-dbas that might be more appropriate.

What business problems are you solving with the product? What benefits have you realized?

Needed a quick way to pull data out of the DB.

SQL Developer review by Executive Sponsor in Telecommunications
Executive Sponsor in Telecommunications
Validated Reviewer
Review Source

"Good experience with some fallbacks"

What do you like best?

I like the integracion that it have (full) with Oracle product. I has plenty of functionalities for beginners and pros, if you like to go a little more further i recommend other tool like Toad.

What do you dislike?

I dislike the incompatibilities between SQL Developer and (Java Version + Windows Version) that causes glitches on the gui. If you have some luck its a problem that will never reach you, but sometimes you need to change JDK used o touch some configuration to have it working properly (mainly on the gui)

What business problems are you solving with the product? What benefits have you realized?

We heavily use Oracle database, with SQL Developers our Software Engineers connect to DBRMS.

SQL Developer review by David C.
David C.
Validated Reviewer
Verified Current User
Review Source

"Good program, lags sometimes, like Toad better"

What do you like best?

It has many options, easy to us UI. The tab system is done well and there are many DBA functions that can be used through the tool like checking tablespaces, currently running jobs and running execution plans for queries.

There is a DBA window that you can attach a connection to and if you have full DBA rights, then you can perform your functions via a UI instead of having to type them in a command prompt

What do you dislike?

It uses a lot of resources and it can sometimes just crash. When I try to remote into my work computer from home, sometimes the SQL Developer just closes itself. It gives no warning. Never had that issue using Toad.

I also havent been able to locate the table locks and which sessions are causing those locks at the moment. I hope to be able to find that functionality soon.

Recommendations to others considering the product

Make sure your computer has a good amount of ram since this is a memory hog. I had issues running it with 4 gb ram, its been very smooth with 16gb ram.

What business problems are you solving with the product? What benefits have you realized?

I run analytical queries and test how fast queries are running when users complain about a report running slow. Also check for hanging sessions and can use the tool to request the DBAs to kill the job since I dont have any DBA privileges myself.

SQL Developer review by Joseph H.
Joseph H.
Validated Reviewer
Verified Current User
Review Source

"The standard GUI for databases"

What do you like best?

Written in Java (I think), it can interface pretty much with any database that has a JDBC connector. You might have to tell it where the appropriate jar is, but that's not too difficult. Navigating tables, views, etc is pretty easy, much like navigating a file system.

What do you dislike?

If a query is taking a long time, SQL developer will freeze.

Recommendations to others considering the product

Another case of "everyone uses it, so you might as well use it." Any SQL queries you develop using it will work outside of SQL developer anyway.

What business problems are you solving with the product? What benefits have you realized?

Designing and developing database schemas to solve various problems, both in the classroom and in the real world. So much easier than a command line interface.

SQL Developer review by User in Investment Banking
User in Investment Banking
Validated Reviewer
Verified Current User
Review Source

"SQL Developer Product Review"

What do you like best?

It is easy to use and provides plugin to major vendors like Sybase , Oracle , MySQL and SQLServer. One can easliy view the table and its DDL structure.One can amend the data in bulk through the GUI provided.One can create and run stored procedures , triggers through SQL Developer also.

What do you dislike?

It works well with oracle but for Sybase tables i doesn't show the constraints and indexes of a particular table.

Recommendations to others considering the product

Please use this tool.The basic version is free and does most of the job needed for a SQL Programmer.It can run SQL Queries , enable you to view the table structure , amend the data in bulk and allow one to run queries on Sybase and MySQL tables as well.One can write stored procedures , triggers and views as well. using SQL Developer.It also allows one to import or export data in tables.

What business problems are you solving with the product? What benefits have you realized?

I am currently working on an MIS Application for which I use SQL Developer for viewing tables and running queries and stored procedures.

SQL Developer review by User in Oil & Energy
User in Oil & Energy
Validated Reviewer
Verified Current User
Review Source

"Simple and Easy Tool for Oracle DB"

What do you like best?

I use sql developer to go look up oracle information directly from the backend tables rather than going through oracle forms. Save so much time once you learn the table structures. The tool can also help you build some simple scripts/reports. Ability to view the code behind custom oracle views they have behind the forms.

What do you dislike?

In my experience, browsing through the objects/fields by expanding/collapsing is very slow. Also exporting large result sets in excel format sometimes crashed.

Recommendations to others considering the product

You can save so much time by learning the table structures and using this tool to directly lookup information without having to go through oracle forms. Also a great took to do some data analytics.

What business problems are you solving with the product? What benefits have you realized?

Build simple reports, check on Oracle setting across multiple organizations from a single place using a simple script.

SQL Developer review by User in Marketing and Advertising
User in Marketing and Advertising
Validated Reviewer
Verified Current User
Review Source

"Does what it needs to do"

What do you like best?

The little limitation that SQL has on file size versus Excel, obviously! The interface is pretty simple but kind of archaic at the same time. It doesn't necessarily have to have a beautiful interface to be trustworthy but it might be less scary to novices/beginners.

What do you dislike?

As somewhat of SQL novice, I don't like when there are errors, SQL doesn't show you how to fix them as it does in Excel. Perhaps that is part of the understanding with SQL, that you are expert enough to know where you code is broken.

What business problems are you solving with the product? What benefits have you realized?

We get multiple sources of data in different file formats and SQL is great at combining files, especially large ones. It is nice to have a repository for these files and be able to link different data points into one table.

SQL Developer review by User
User
Validated Reviewer
Verified Current User
Review Source

"Great application!"

What do you like best?

It is very easy to add various connections, formatting for SQL is in-built, the query output is available in various the extraction of outputs to reports.

What do you dislike?

The choice of fonts and query output available. If a queries in a script are not terminated properly, and the query where the cursor is run, it executes the full script, and at times executes more queries than intended.

Recommendations to others considering the product

I'd recommend anyone trying to use an editor for SQL

What business problems are you solving with the product? What benefits have you realized?

I use SQL Developer for data analysis and SQL development.

SQL Developer review by SHAILESH P.
SHAILESH P.
Validated Reviewer
Verified Current User
Review Source

"Using SQL DEVELOPER"

What do you like best?

The easiness of using SQL developer is awesome. Its really comfortable to use.

What do you dislike?

managing with mulitple connections sometimes founds a bit of problem with opening multiple tables and viewing data is from different connections is bit slow.

Recommendations to others considering the product

Its really a good software to work on in terms of performance checking of queries.

What business problems are you solving with the product? What benefits have you realized?

I write queries and PL SQL blocks on SQL developer to debug the issue and also for performance checking how costly the query is.

SQL Developer review by User in Hospital & Health Care
User in Hospital & Health Care
Validated Reviewer
Verified Current User
Review Source

"SQL Developer - integrated development environment"

What do you like best?

1. Easy to install by simply unzipping the downloaded file and running the executable

2.Beneficial to users of alternative platforms

3.Client server network traffic can be avoided by using Oracle SQL Developer because users of Oracle SQL Developer can install this software on the Database server and the users can be remotely connected from their desktops

4.Oracle Home is not required while using Oracle SQL Developer as the connectivity to the database is via JDBC thin driver

5.It is free

What do you dislike?

1. Absence of the schema browser in SQL Developer

2.Absence of a Modeler and Data Modeling features

What business problems are you solving with the product? What benefits have you realized?

1.Run analytical queries to test the performance of the different reports used in the day to day business.

2. Data maintenance and monitoring for the business applications

SQL Developer review by Rubén S.
Rubén S.
Validated Reviewer
Verified Current User
Review Source

"Useful but needs improvements"

What do you like best?

This application is very easy to use. You can add many connections and browse different schemas easily. The SQL completion works very well and it has additional features like database comparison or database copying.

What do you dislike?

The application has some performance issues, if you keep the application open but idle for some time it becomes unresponsive (at least the linux version).

What business problems are you solving with the product? What benefits have you realized?

I'm web application developer and I use it for DB schema creation and manipulation, as well as data checking.

SQL Developer review by Consultant in Information Technology and Services
Consultant in Information Technology and Services
Validated Reviewer
Review Source

"one stop solution for all the database needs"

What do you like best?

The user Interface is quite easy to interact with and very fascinating when it comes to manipulate with the data from the database

What do you dislike?

When we have to remotely access database through a VPN (virtual private connection) connection and somehow if we forget to turn on the VPN(virtual private connection) and connect to database through SQL Developer, it takes time to respond and crashes in a rare scenario like this.

Recommendations to others considering the product

I highly recommend this software as it helps you to manipulate data and manage database connections with ease.

What business problems are you solving with the product? What benefits have you realized?

As a software engineer, while fixing a bug we need query data to understand if the query is returning correct data or not. hence this helps us rectifying the problem.

SQL Developer review by Roger C.
Roger C.
Validated Reviewer
Verified Current User
Review Source

"Developing oracle applications with SQL Developer"

What do you like best?

The tool was very intuitive to use. There was only a small learning curve before a new user could be very productive. Menus contained the items you'd assume would be under them. Icons reflected the actions they represented

What do you dislike?

It was possible to display too many icons, too many menus, too many windows. The screen became intimidating. Even experienced users could become lost.

Recommendations to others considering the product

Given a basic understanding of Oracle and SQL, this product should be an immediate help to developers and business users. Establishing this as "the" SQL tool for a team of developers increases the benefits you can reap from it.

What business problems are you solving with the product? What benefits have you realized?

The project was to merge legacy data into the current oracle database. We needed to not only create scripts to accomplish the merger, but to also be able to validate that other data merges were successful. Being able to create and populate tables on the fly saved a lot of time. Many of the functions were needed to use were already available to us.

SQL Developer review by Jan P.
Jan P.
Validated Reviewer
Verified Current User
Review Source

"SQL Developer as everyday tool"

What do you like best?

It is one of the few IDE for PL/SQL development which can be run on OSX and Windows and it is trying to be real IDE not just notepad with syntax highlight (but still so much to achieve).

What do you dislike?

Instability and plenty of annoying bugs, which leads to restarting SQL developer at least twice a day (and I'm not counting that it at least twice a day dies spontaneously)

Recommendations to others considering the product

On OSX there is not so many choices, on windows you can choose better.

What business problems are you solving with the product? What benefits have you realized?

fulltime PL/SQL development of financial application

SQL Developer review by User in Computer Software
User in Computer Software
Validated Reviewer
Verified Current User
Review Source

"Intuitive and Free SQL Tool"

What do you like best?

While the license of SQL Developer is a proprietary license by Oracle, it is a free product. It is very easy to pick up and get started with intuitive tools and user interface.

What do you dislike?

Like some of the other tools from Oracle, the software can be a bit buggy and crash often. I've noticed this using the SQL Developer software on Mac OSX.

Recommendations to others considering the product

Since it's free, it's definitely recommended to give it a download. Take a look at the various plugins that are available since it can expand the functionality of the software.

What business problems are you solving with the product? What benefits have you realized?

I've been using this tool with various clients to manage some simple relational databases. Since it's a completely free product, I can throw it on all of my machines when I need to manage the database side of the projects.

SQL Developer review by User in Financial Services
User in Financial Services
Validated Reviewer
Review Source

"Perfect Database product"

What do you like best?

I am currently using PL/SQL developer at my place of employment. Its a very easy tool to analyze data and perform arithmetic operations on data. The UI is simple and makes it easy to type large codes. Querying data is really fast.

What do you dislike?

The PL/SQL developer lacks certain features like data import. If you need to import data from an external object you would need additional tools like access. Also moving around schema can get sometimes get tough. Timestamp fields are also difficult to view. You either need to see empty timestamp like 00:00 if the original column did not have time element or if you alter the NLS you cannot see the time element even if the column had time data.

Recommendations to others considering the product

Going good.

What business problems are you solving with the product? What benefits have you realized?

Data analysis.

SQL Developer review by Apeksha G.
Apeksha G.
Validated Reviewer
Review Source

"Ease of work with SQL Developer "

What do you like best?

The easy to use interface makes your tasks easier. I also like the intellisense technology that gives you recommendations for auto-complete. It helps you save time

What do you dislike?

It can use some advanced features as present int the tool TOAD

Recommendations to others considering the product

I would highly recommend using SQL developer as the complete DB solution.

What business problems are you solving with the product? What benefits have you realized?

I am working on RDBMS DML. It provides me with a much cleaner UI and makes it easier to interpret the results

SQL Developer review by Brad K.
Brad K.
Validated Reviewer
Verified Current User
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"Great product for multiple database technologies."

What do you like best?

Despite being developed by SQL Developer allows users to easily manage connections Oracle databases as well as to a multitude of database technologies such as SQL Server, Mysql, and Teradata through third party plugins. The tool is very intuitive, and you can't beat the free price.

What do you dislike?

After idling for a long time, the application will occasionally stop responding and the user may be forced to quit. A similar problem exists when refreshing connections to a database after the connection times out. It can be a hassle to restart the application.

Recommendations to others considering the product

You can't beat this level of a product for free! SQL Developer beats many other non-free database front-ends.

What business problems are you solving with the product? What benefits have you realized?

Data integration tasks using Oracle FDMEE and ARM.

SQL Developer review by Daniel F.
Daniel F.
Validated Reviewer
Verified Current User
Review Source

"Best SQL IDE out there!"

What do you like best?

SQL Developer integrates everything I've ever wanted or needed to do developing in SQL.

What do you dislike?

There's an occasional time that a query/process won't be able to be stopped and I must kill the application.

Recommendations to others considering the product

It's a highly used software, and for good reason. I believe it's the best SQL IDE available. I can quickly work through it creating my SQL scripts. I feel very enabled using it.

What business problems are you solving with the product? What benefits have you realized?

Quick development of SQL scripts with built in tools to create tables/links/synonyms, etc.

SQL Developer review by User in Information Technology and Services
User in Information Technology and Services
Validated Reviewer
Verified Current User
Review Source

"Sql Developer is very good free tool available for pl/sql development"

What do you like best?

GUI is very good and it is helpful for developers to analyze the data and create a Entity Relationship Diagram. We can compare sql reports here.

What do you dislike?

this should be more compatible for schema comparison.

Recommendations to others considering the product

Its very good tool and free available on oracle website. Any one can take this and use it directly.

What business problems are you solving with the product? What benefits have you realized?

Creating pl/sql program, sql scripts, er diagrams and code debug

SQL Developer review by User in Higher Education
User in Higher Education
Validated Reviewer
Verified Current User
Review Source

"Oracle SQL Developer"

What do you like best?

Love Oracle SQL Developer. It is my tool of choice as a DBA and Programmer. There are so many different tools in this software package. I am a Mac user and I was very happy to see this. So easy to set up and use. Can't beat the cost too.

What do you dislike?

The one thing I would say is a disadvantage of Oracle SQL Developer is that it is memory intensive. I have a problem with memory hogs like this.

What business problems are you solving with the product? What benefits have you realized?

Yes absolutely. We all use this tool to write adhoc queries and some reporting.

SQL Developer review by User in Information Technology and Services
User in Information Technology and Services
Validated Reviewer
Verified Current User
Review Source

"Great tool"

What do you like best?

Easy to use and very effective features to use for a database. The GUI is very good and it offers best competition to other database clients such as Toad.

What do you dislike?

Nothing much to dislike but adding other new features is greatly appreciated.

What business problems are you solving with the product? What benefits have you realized?

Logiing in to the database, running queries, exporting and importing data, graphical interface of the relational database etc.

SQL Developer review by User
User
Validated Reviewer
Review Source

"Great environment to manage and query multiple databases"

What do you like best?

Easy management of multiple connections to different databases. The learning curve is not steep and is really ideal for developers that just need to do simple actions like queries..

What do you dislike?

For more complex actions, it might not be the best. The intuitiveness of where certain actions should be isn't too great, and sometimes takes multiple clicks just to get there. Also, the autocomplete does not function properly pretty often.

What business problems are you solving with the product? What benefits have you realized?

With a low learning curve, it is easy to train new people on how to access our data.

SQL Developer review by User in Financial Services
User in Financial Services
Validated Reviewer
Verified Current User
Review Source

"A great companion to Oracle Database"

What do you like best?

Native support to Oracle Database, has all the features that are needed for Oracle DB, free and powerful SQL IDE.

What do you dislike?

Support Oracle DB only. If you need to work across different DB engines, you have to use other tools such as Navicat.

Recommendations to others considering the product

If you are using Oracle DB, that is the number one tool you should consider first.

What business problems are you solving with the product? What benefits have you realized?

We are using SQL developer to manage database tables, triggers, procedures. We also use it to debug and test SQL statements.

SQL Developer review by User in International Affairs
User in International Affairs
Validated Reviewer
Review Source

"Not good enough but... free"

What do you like best?

The best thing is that SQL Developer is free (comes with Oracle installation), and also uses native libraries.

Obviously, if you are using Oracle DBS, you will not have any connection problems.

It's very easy to install, and it has a very good support

What do you dislike?

There are much much better options in the market, specially TOAD and PLSQL Developer, but, they are not free.

SQL developer is slow, very slow, and believe it or not, it has a lot of bugs.

Also the interface is not very friendly.

What business problems are you solving with the product? What benefits have you realized?

At least, provides all the necessary to a developer to work with Oracle DBs

SQL Developer review by User in Automotive
User in Automotive
Validated Reviewer
Review Source

"Powerful Database Tool that grows with you"

What do you like best?

I've been able to connect to several variants of databases with a single installation of Oracle SQL Developer.

By utilizing the External Plugins DLL extension, I've successfully used this tool to interface with IBM DB2, PostgreSQL, Oracle DBs, MySQL, Sybase, SQLServer, and Access.

Whatever you throw at this thing, you can find a way to connect to your database.

The UI is easy to walk through and once you learn how to pin tables, it is an easy tool to compare tables side by side.

What do you dislike?

Installation was not as straight forward or out-of-the-box.

Plugins can be a little tricky at first and may take a few tries to get configured correctly.

It would be great if there was an easier way of sharing connections with colleagues to allow for quicker team set up.

What business problems are you solving with the product? What benefits have you realized?

Internal business applications for support.

SQL Developer review by Claudia P.
Claudia P.
Validated Reviewer
Review Source

"Base de datos muy completa"

What do you like best?

Tiene multitud de funciones, que te permite estar conectado a diferetentes bases de datos a la vez.

What do you dislike?

Cuando haces consultas muy pesadas que se queda colgado.

What business problems are you solving with the product? What benefits have you realized?

Por mi trabajo necesito trabajar con Bases de datos, sin un SQL seria mucho peor.

SQL Developer review by Scott M.
Scott M.
Validated Reviewer
Review Source

"Good for a standalone database tool."

What do you like best?

I like the tool as a standalone database tool for modifying tables and cells.

What do you dislike?

It doesn't have as many features as other database tools I've used in the past, but good overall.

What business problems are you solving with the product? What benefits have you realized?

Modifying database tables, cells, running queries, etc.

SQL Developer review by User in Information Technology and Services
User in Information Technology and Services
Validated Reviewer
Verified Current User
Review Source

"SQL to create reports"

What do you like best?

reliability and consistency are two great attributes

What do you dislike?

sometimes it seems like the error messages are not accurately informing me of my mistake in my syntax

What business problems are you solving with the product? What benefits have you realized?

we use SQL to run reports and pull data also to update or change data in production

SQL Developer review by User in Internet
User in Internet
Validated Reviewer
Review Source

"Oracle SQL developer is the IDE for most of the database operations. "

What do you like best?

Its free! It provides interface for all PL SQL modules, Java procedures, HTML, XML etc. It supports all developer operations like create tables, triggers, packages etc and also DBA features like snapshots, RMAN etc. Oracle SQL developer can be integrated with Oracle APEX! Its very useful for PL SQL Unit testing. The other nice feature is we can see multiple datagrids at a time for multiple queries ran in a query window.

The main advantage with SQL Developer from Toad is its free.

What do you dislike?

Debugging and exception handling features are better handled in toad for PL SQL packages. Sometimes GUI gets slower and not responding. Some of the other databases integration may be painful!

Recommendations to others considering the product

This is a better software in the market and as it is free do not compare with some robust licensed software. Its free and its great!

What business problems are you solving with the product? What benefits have you realized?

Writing SQL procedure, functions and other objects to provide data loading features and for data analysis.

SQL Developer review by User in Information Technology and Services
User in Information Technology and Services
Validated Reviewer
Verified Current User
Review Source

"more than five years to take use of this tool"

What do you like best?

manipulate many multiple databases at the same time, that's great for us to work on different environments.

What do you dislike?

It took too much memories even if only open one tab.

Recommendations to others considering the product

I'd like to take use of this tool to manipulate the oracle DB

What business problems are you solving with the product? What benefits have you realized?

manipulate many multiple databases

SQL Developer review by Administrator
Administrator
Validated Reviewer
Review Source

"Sub optimal DB management tool for a sub optimal DB(in most caese)"

What do you like best?

The product is free, relatively easy to use.

What do you dislike?

This product is extremely unstable, the default shortcuts are counter intuitive (based on many other popular management tools ) some of which cause the software to crash. It is extremely unresponsive, with no visual indicator as to why.

Recommendations to others considering the product

If you have to, its a fine solution. Buy toad if you can.

What business problems are you solving with the product? What benefits have you realized?

Remote db access / management of oracle based DBs

SQL Developer review by User in Internet
User in Internet
Validated Reviewer
Review Source

"SQL Developer tools"

What do you like best?

The tool has many UI icons and interfaces to build and execute queries. Also, the export/import features are nice. The prompts with the table/database/view name for accurate object names.

What do you dislike?

The connection hangs very often and needs to be reconnected. many times the application needs to be restarted and you might loose all your open data. this is very irritating.

Recommendations to others considering the product

To avoid connection timeouts disconnect and reconnect your connections according to use.

What business problems are you solving with the product? What benefits have you realized?

I manage my application database through it. for testing new queries and for data modelling.

SQL Developer review by Administrator in Information Technology and Services
Administrator in Information Technology and Services
Validated Reviewer
Verified Current User
Review Source

"Versatiles and reliable system, great for large scale databases."

What do you like best?

Versatile, well structured. Can be used for large complex databases.

Good interaction with the front end.

What do you dislike?

Whenever I need to refresh connection to the server (it is time limited), I have to shut down the Developer completely and restart it.

The refresh connections isn't functioning well.

What business problems are you solving with the product? What benefits have you realized?

Creating and maintaining a database of clinical and research database for a department in a large hospital system.

Migration of legacy data from old databases (Access, Excel, etc.)

Legacy data validation.

Data export scripts to a 3rd party.

I like the structure of the Developer environment.

SQL Developer review by User
User
Validated Reviewer
Review Source

"Great SQL tool!"

What do you like best?

The graphical tree on the left showing all the schema objects is great. There are also many useful toolbar buttons, right-click menus and drag & drop features. You can also now create connections to cloud databases.

What do you dislike?

SQL developer occasionally freezes and crashes. Also there is no way to terminate an executing PL/SQL program once it has started.

What business problems are you solving with the product? What benefits have you realized?

It has helped me write code faster and therefore be more productive.

SQL Developer review by Consultant in Marketing and Advertising
Consultant in Marketing and Advertising
Validated Reviewer
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"Easy and Quick from installation to learning and using!!"

What do you like best?

This is peobably the first and the oldest tool i have worked upon. I really had no learning curve. It easy and free to install. It allows you to connect to your database with any complications.

What do you dislike?

The only thing that i did not like was that there have been absolutely no major improvements. Its been the same for a few years now.

Recommendations to others considering the product

Its way better than many other free or cheap softwares available in the market.

This is worth giving a try..

What business problems are you solving with the product? What benefits have you realized?

We used it for campaign management.

It helped in developing, executing, prioritizing and reporting multi-channel based campaigns to successfully acquire/retain and enhance revenue.

SQL Developer review by User in Import and Export
User in Import and Export
Validated Reviewer
Verified Current User
Review Source

"SQL Developer Review"

What do you like best?

Easy to use, rarely ever have problems with it crashing etc

What do you dislike?

Only wish that there was an easier way of organizing the various scripts that I have. I usually jjust comment them out.

What business problems are you solving with the product? What benefits have you realized?

I am running different scripts for programs daily. I update files daily. It helps us push out files and keep organized with invoices.

SQL Developer review by User
User
Validated Reviewer
Verified Current User
Review Source

"User friendly"

What do you like best?

The Interface is very user friendly, its pretty easy to figure out for a first time user. I use the built-in filter feature a lot and the fact that I can connect to and query multiple instances of databases on the same interface is nice.

What do you dislike?

It can get too slow some times. Throws weird errors when connected for too long

What business problems are you solving with the product? What benefits have you realized?

used to manage oracle databases

SQL Developer review by Administrator in Education Management
Administrator in Education Management
Validated Reviewer
Review Source

"Useful tool for connecting to Databases"

What do you like best?

Easy to install, queries run fast, and let you know when there is an error

What do you dislike?

It is slow to grab fields for you, ie: typing a table or alias and loading a list of available fields to choose from.

Recommendations to others considering the product

Quick and easy to install, works with most SQL Database connections.

What business problems are you solving with the product? What benefits have you realized?

Finding data issues in the database and generating data dumps for reports.

SQL Developer review by Víctor B.
Víctor B.
Validated Reviewer
Review Source

"Restart the product again"

What do you like best?

Access to any number of Oracle databases

What do you dislike?

It is always necessary to restart the application since it uses to lose the active connection

What business problems are you solving with the product? What benefits have you realized?

Database modeling and mainteinance

SQL Developer review by Arvind K.
Arvind K.
Validated Reviewer
Review Source

"User of SQL Developer"

What do you like best?

I Like sql developer but the problem is I did not felt that it has some unique features..later I started using Toad

What do you dislike?

No Major improvements in the software since long.

Recommendations to others considering the product

They can release many new enhancements which has been requested by the user.

What business problems are you solving with the product? What benefits have you realized?

Initially when we started our organization, we used SQL developer to manage our database.

SQL Developer review by User in Hospital & Health Care
User in Hospital & Health Care
Validated Reviewer
Review Source

"SQL Developer"

What do you like best?

I love the ease of use. I can query data in an extremely easy fashion using my organization's metadata

What do you dislike?

With not many Query tools to compare it too, it is difficult to say. I really enjoy the overall interface of this tool

What business problems are you solving with the product? What benefits have you realized?

Organizational initiatives is the primary use

SQL Developer review by User in Information Technology and Services
User in Information Technology and Services
Validated Reviewer
Verified Current User
Review Source

"Handy tool but only have core functionality"

What do you like best?

Core functionality. Simple and light and it is free

What do you dislike?

No additional functionalities such as Table relation diagram.

What business problems are you solving with the product? What benefits have you realized?

Its free so easy test script, modify DB

SQL Developer review by Rohit V.
Rohit V.
Validated Reviewer
Review Source

"Simple and Essential"

What do you like best?

I have used this product to remotely administer an Oracle 10g database and monitor database health. This tool is stable and simple to use.

What do you dislike?

None. I faced no issues while using this product.

Recommendations to others considering the product

I would recommend this product to connect and maintain remote databases.

What business problems are you solving with the product? What benefits have you realized?

Remote administration of Oracle 10g database. Also used this tool for data export, import and manipulation.

SQL Developer review by Industry Analyst / Tech Writer in Higher Education
Industry Analyst / Tech Writer in Higher Education
Validated Reviewer
Review Source

"SQL Developer Reporting"

What do you like best?

SQL Developer is a great beginner product for someone who is trying to learning SQL writing.

What do you dislike?

Very basic. Could add more functionality for those who are trying to do more advance SQL writing.

What business problems are you solving with the product? What benefits have you realized?

SQL Developer is used to write basic SQL statements for pulling information from our student database.

SQL Developer review by Consultant in Information Technology and Services
Consultant in Information Technology and Services
Validated Reviewer
Review Source

"Easiest language for developers"

What do you like best?

Much easier than python. Can streamline and do more things better than R or Python. It’s comprinke with many other tools like excel.

What do you dislike?

I hate that if a syntax is incorrect it doesn’t tell you exactly what’s wrong

What business problems are you solving with the product? What benefits have you realized?

Moving government data into another tool

SQL Developer review by Consultant
Consultant
Validated Reviewer
Review Source

"Sql"

What do you like best?

I like the warehouse and how easily Oracle could be integrated across applications.

What do you dislike?

I think the language is quite limited. It is a bit different than Microsoft which was a change for me when I transitioned.

What business problems are you solving with the product? What benefits have you realized?

Helping clients optimize their business. Improvement in top and bottom lines.

SQL Developer review by User in Hospital & Health Care
User in Hospital & Health Care
Validated Reviewer
Review Source

"Free tool for sql development"

What do you like best?

This is free available and support all oracle new feature for development and testing.

What do you dislike?

data modeling is not advance and ER diagram is not good.

Recommendations to others considering the product

definately. Yes.

What business problems are you solving with the product? What benefits have you realized?

development. This is very good in terms of use and features. PL/SQL development is very easy with this tool.

SQL Developer review by User in Information Technology and Services
User in Information Technology and Services
Validated Reviewer
Review Source

"Good SQL client"

What do you like best?

Best tool for connecting Oracle database server

What do you dislike?

Nothing much to dislike, but preferred to have inbuilt support for other database like mysql and db2

Recommendations to others considering the product

Suggest to anyone looking for good reliable sql client

What business problems are you solving with the product? What benefits have you realized?

helps in connecting the db server to perform CRUD operation

SQL Developer review by Administrator in Financial Services
Administrator in Financial Services
Validated Reviewer
Review Source

"Convenient SQL Editor"

What do you like best?

SQL Developer is a free sql programmer for oracle DBA.

It is very convenient and easy to use.

What do you dislike?

Data exporting in Microsoft Excel format does not work for huge data.

Recommendations to others considering the product

I recommend to others to use the native sql developer implemented by Oracle company.

What business problems are you solving with the product? What benefits have you realized?

Daily usage for Oracle database management. Nothing special.

SQL Developer review by Ryan Z.
Ryan Z.
Validated Reviewer
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"It is powerful but a little user unfriendly."

What do you like best?

The power of being able to sift through huge amounts of data, quickly.

What do you dislike?

It's tough to tell where mistakes are. I also wish all SQL softwares contained the same language syntax.

Recommendations to others considering the product

Make all SQL softwares consistent.

What business problems are you solving with the product? What benefits have you realized?

Usually synthesizing data. Makes this quick and efficient.

SQL Developer review by vijay k.
vijay k.
Validated Reviewer
Review Source

"sql"

What do you like best?

ease of use , user friendly , features needed for an admin

What do you dislike?

i have all the features required ,, so no issues

What business problems are you solving with the product? What benefits have you realized?

NA

SQL Developer review by Consultant in Information Technology and Services
Consultant in Information Technology and Services
Validated Reviewer
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"Oracle SQL Developer"

What do you like best?

Free. Tool that is easy to configure. Used for running queries, developing PL/SQL, database management, etc.

What do you dislike?

Quite heavy to install. Hogs memory. Cannot run on mobile devices (so far as I'm aware of).

What business problems are you solving with the product? What benefits have you realized?

As an ETL developer, a tool like Oracle SQL Developer is essential for checking data structure, correctness, volume, etc.

SQL Developer review by User in Information Technology and Services
User in Information Technology and Services
Validated Reviewer
Review Source

"Perfect light weight dB access tool"

What do you like best?

Lightweight and not resource intensive like other dB access tools

What do you dislike?

The level of explain plan representation is not comparable with toad

What business problems are you solving with the product? What benefits have you realized?

It provides easier access to reports with a ui

SQL Developer review by Consultant
Consultant
Validated Reviewer
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"Reviewing sql developer"

What do you like best?

Excellent developer tool for connecting to oracle data sources

What do you dislike?

Nothing to dislike, very user friendly..

What business problems are you solving with the product? What benefits have you realized?

Generating sql queries and stored procedures

SQL Developer review by Winston K.
Winston K.
Validated Reviewer
Verified Current User
Review Source

"Pretty good administration tool for Oracle"

What do you like best?

Allows you to easily connect to an Oracle database and view the data structure, build queries.

What do you dislike?

The query builder is good, but not spectacular. It doesn't work well as a data modeling tool.

Recommendations to others considering the product

There are several programs for connecting to an Oracle 11g database including SQL*Plus and APEX. I find SQL Developer to be the most user friendly.

SQL Developer review by Ahmed S.
Ahmed S.
Validated Reviewer
Review Source

"Excellent Oracle database tool"

What do you like best?

A very good desktop tool allows you to connect with your database and do many operations in a very easy way without any complexity

What do you dislike?

Sometimes it doesn't view the retrieved data in an appropriate way when there are many data retrieved from the database

Recommendations to others considering the product

I hope you try it because it is very good tool to use. It'll make your work easier

Kate from G2 Crowd

Learning about SQL Developer?

I can help.
* We monitor all SQL Developer reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. Validated reviews require the user to submit a screenshot of the product containing their user ID, in order to verify a user is an actual user of the product.