Oracle SQL Developer Information Reviews & Insights

Score8.7 out of 10

491 Reviews and Ratings

Community insights

TrustRadius Insights for Oracle SQL Developer are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.

Pros

Seamless Integration: Users have consistently praised the seamless integration of Oracle SQL Developer with all versions of Oracle databases, eliminating the need for complex setup processes. This feature has been highlighted as a major advantage, enhancing user experience and workflow efficiency.

Easy Set-up and Installation: Reviewers appreciate the straightforward set-up and installation process of Oracle SQL Developer, along with its exceptional cross-OS compatibility. The ease of getting started with the tool has been positively acknowledged by users, making it accessible across different operating systems.

User-Friendly Interface: The simple user interface and effective functions contribute to the overall user-friendliness of Oracle SQL Developer, as expressed by users in their reviews. The intuitive design and smooth navigation enhance usability, allowing users to easily access and utilize various features within the application.

Reviews

11 Reviews

Information

Oracle SQL Developer the Masterclass for Database Work

Rating: 8 out of 10

Incentivized

June 4, 2021

Use Cases and Deployment Scope

Oracle SQL Developer is used to solve production issues for our client. It is used across the whole organization by different support and development teams. The business problems that it solves is production issue that occur when the business runs. Using Oracle SQL Developer we ensure that our business runs smoothly.

Pros

The various contents of a database can be viewed using the connection tree
We can run SQL queries to generate reports in various formats
Debugging of queries is smooth

Cons

More RAM usage by SQL Developer which makes it slow sometimes for big queries
The database automatically gets disconnected when it is idle for sometime
Auto-completion of queries is not available

Likelihood to Recommend

SQL Developer is well suited for solving production issues by doing data fixes. SQL Developer is well suited for extracting reports from database. It is well suited for debugging queries. It is well suited for designing and developing new database.PL/SQL development can easily be done through it. It is best suited for doing DML and DDl updates of database.

Ankur Karmakar

Programmer Analyst Trainee in Engineering at Cognizant (Computer Software, 10,001+ employees)

Vetted Review

1 year of experience

View profile

Oracle SQL Developer: One of the best Softwares I Have Ever Used

Rating: 9 out of 10

Incentivized

April 28, 2021

Use Cases and Deployment Scope

[Oracle] SQL developer is used as [a] graphical interface to oracle DB. The main user of SQL developer is [a] user [that] can access the DB very efficiently. It is used by [the] IT department in our organization. [Writing] and executing the query is easy and we can easily address in the query. Also, we can easily connect with multiple database through this so the work can be happen in faster way.

Pros

[You] can connect multiple databases [very] easily.
[Anyone] can write [queries] easily and see the errors.
[It] generates [an] execution plan, which helps to optimize the query.

Cons

[Good] filtering and reporting is not available.
[More] documentation should be available in software so that user will get all the help in it.
[Memory] usage should be less.

Likelihood to Recommend

When you have multiple databases to connect, it is the best software to user. [You] will get to know [the] full report for your query execution. [The] [history] feature is very useful to check [the] query. [Importing] and [exporting] data is very easy and is in various format, such as: Excel, CSV etc. [Installation] or Setup is very and [easily] handy.

Verified User

Team Lead in Information Technology (Computer Software company, 51-200 employees)

Vetted Review

8 years of experience

Software for everyone using DB

Rating: 8 out of 10

Incentivized

April 13, 2021

Use Cases and Deployment Scope

Oracle SQL Developer is used by each and every department in my organization but not all employees work on it. Mainly it is used to store data my organization works on. It is used to keep records of my company for a long time without any need to delete--also hassle free maintenance of data.

Pros

Simple UI. Even new joiners can easily use it.
Autocomplete feature. It recommends a completion for every line.
Debugging is easy. Oracle SQL Developer displays what ever the error is.
Supports various kind of DB. Not just SQL.
Easy installation and setup.
It is free to use and one doesn't need to buy anything.
Easily export data into different formats like Excel, TSV file, text file, html, etc.

Cons

There are fewer features compared to other software available in market.
Good quality reporting, sorting ,filtering features are not available.
Lags upon heavy usage.
Connection from DB gets disconnected if query is stopped.
Query running status still comes even if at the backend the query has been stopped and person keeps on waiting.

Likelihood to Recommend

It is well suited when one doesn't need to work heavily on DB; a person who has just started learning SQL or working on SQL can work easily using SQL developer.

SQL developer is not suited to a person who is a database administrator or works on creating big stored procedures, as it will feel laggy and supports fewer features.

Sushant goyal

Analyst in Finance and Accounting at Airtel International LLP-Airtel Africa (Telecommunications, 10,001+ employees)

Vetted Review

2 years of experience

View profile

Must-have SQL editor

Rating: 7 out of 10

Incentivized

April 12, 2021

Use Cases and Deployment Scope

Oracle SQL Developer is used across the company by different users depending on their preferences. Since it’s free, anyone can download and use it. It is best SQL editor for Oracle and other databases--lots of features and easy to use. It’s reliable and performs better than other similar tools. It helps database users to query, manage data in large enterprise databases like Oracle and Teradata. Oracle SQL Developer also has features for database migration, data modeling, data mining, import/export, versioning, analytics reports, change management, debugging, and logging.

Pros

Database querying SQL
Data modeling and design
Database explorer
Data filtering, export/import
Database object management
Data migration
Debugging
Version control
OLAP
Analytics reports
Sessions
Database comparision

Cons

Better user interface
Native support for other databases
Autocompletion
Performance

Likelihood to Recommend

It’s best suited if your company works with different databases and needs a common SQL editor to manage and query data for its user. Oracle SQL Developer works very well with Oracle but also some other relational databases. If you do lot of querying and import/export in database, then this is tool for you. It's ideal for DBAs as well for data modeling, management, session monitoring, logging, versioning, etc.

It’s not ideal for no relational/noSQL or big data. It is not tool for visualization. It’s best suited for querying using SQL. Companies that are looking for free tools that are robust and most useful should definitely look at it.

Verified User

Manager in Corporate (Telecommunications company, 10,001+ employees)

Vetted Review

9 years of experience

A Must Have Tool for Oracle SQL Database Administrators!

Rating: 8 out of 10

Incentivized

October 9, 2019

Use Cases and Deployment Scope

Our database administration team is using Oracle SQL Developer for the sake of increased productivity. Instead of writing SQL queries out, they use Oracle SQL Developer's IDE interface to quickly create complex queries. Some other features we use include browsing/managing data, ad-hoc reporting, migrating 3rd party RDBMS systems over to Oracle, and data modeling.

Pros

Flexible GUI. The UI updates of the latest version have made navigating through the various features of Oracle SQL Developer quite easy.
Great Tools for Testing and Developing SQL Scripts. SQL scripting can be a hassle when working with large tables and such. Oracle SQL Developer makes it easy to preview how many rows and tables will be affected.
Ability to Load Data from Different File Formats. Some of our data comes in the form of Excel spreadsheets, XML, and JSON. Oracle SQL Developer allows our database administrators to easily push the data from these formats into our database tables automatically.

Cons

Inability to run multiple queries on the same database. You can only run one query on a given database.
Analytical models created from complex tables isn't accurate, and needs work.
Inability to view multiple tables of a database side-by-side. When trying to find correlations between tables, it would help to be able to see them at once on the same page.

Likelihood to Recommend

Oracle SQL Developer is well-suited for all companies that are using Oracle SQL Databases. First and foremost, it is absolutely free, and there are many free in-depth tutorials and documentation online to answer all of your questions. No matter the amount of experience, I am sure all database administrators will be able to work much more productively with their organization's databases through this IDE.

Verified User

Engineer in Information Technology (Computer Software company, 51-200 employees)

Vetted Review

3 years of experience

Oracle SQL Developer Review

Rating: 5 out of 10

Incentivized

September 18, 2019

Use Cases and Deployment Scope

Oracle SQL Developer is the choice of product to write pl/sql code and is easy to connect to multiple databases. This is a tool which allows to connection to Oracle products as well and hence why it is useful when you need one glass pane for all your tools.

Pros

Oracle SQL Developer is one glass pane to look for all connections across all databases.
This can work across various environments and provides good value for money.
This is developer oriented and maintains great connection pool to databases.

Cons

Not easy to install - our IT and compliance policies made it hard to get this installed.
If there are security policies across companies, it is not easy to work way out to get product installed. The product is good, but the way it is delivered is not the best.
This product need better UI to search data across various panes.

Likelihood to Recommend

Oracle SQL Developer allows one pane of glass to make it valuable, and saves times while working on various other products of Oracle and other software. Oracle SQL Developer is good for any type of company, big or small, that needs it for development. The catch is, the way people are using it needs to be monitored. This is because it is a single product that connects to production and non-production, it is easy to make a mistake and push to the wrong instance.

Verified User

Engineer in Information Technology (Information Services company, 10,001+ employees)

Vetted Review

1 year of experience

Analyst's Review of Oracle SQL Developer

Rating: 3 out of 10

Incentivized

September 17, 2019

Use Cases and Deployment Scope

Oracle SQL Developer is our default querying IDE for our analytics zone and a primary way for us to access all the data we store across various programs.

Pros

Easy to connect to a data source - Time to get started is fairly easy given the connection is straightforward.

Cons

It's very barebones, there are so many greater options for querying that provide more dynamic interaction and autocompletion.
Visually, it leaves much to be desired, sometimes it even clips the text on my widescreen monitor.

Likelihood to Recommend

Oracle SQL Developer is well suited for a quick-use scenario where you're not planning to be in it a lot. It's fairly easy out of the box to begin querying.

Verified User

Employee (Internet company, 10,001+ employees)

Vetted Review

2 years of experience

SQL Developer Review

Rating: 9 out of 10

Incentivized

November 30, 2017

Use Cases and Deployment Scope

I use SQL Developer (SD) for PL/SQL development. Being free from Oracle Corp, it is a very cost-effective way to build and maintain PL/SQL code. I like the main editor window that I can execute PL/SQL or SQL and get results. The SQL can be easily saved for future use in the form of a report. There is a nice history function that shows all of the code (last 100 things done I think...) SD executed. This feature is particularly handy when doing some SQL tuning with hints. Another nice feature is that SD supports the APEX environment, right out of the gate! You can easily view the APEX management data right from SD. SD also has code snippets and some code templates. The code snippets are drag and drop bits of code useful for various functions, SQL tuning (there is a category for all of the useful SQL hints), date functions, date/time masks, number/character conversions, and more. I have plugged my various useful SQL into the SD reports making them very easy to run.

Pros

PL/SQL Development: the tool's strength really. SD supports code condensing, parentheses/brace matching, insites (popup windows with data object column names, etc).
I like the report feature...very easy to add your library of SQL to be run as reports. SD works with bind variables in your SQL well too.
The history feature is particularly nice. It's called SQL Recall and it saves quite a number of PL/SQL and SQL code you have been working with for near-future reference and recovery if needed.
The code snippets is very nice. Various functions and function details at your fingertips. Use a drag and drop operation to add to your code.

Cons

SQL Tuning. SD has explained plans but these could easily be improved upon using the latest features of the Oracle RDBMS.
More code templates. You can add your own but the tool seems to be lacking a bit when it comes to pre-existing code examples.
Smaller foot print. The thing is huge and somewhat slow.
Seems every time I get a newer SD, I also have to upgrade the Java environment as well. Would be nice if they picked a rev of Java and stuck to it.

Likelihood to Recommend

SD is well suited for PL/SQL development, some data analysis, and executing of SQL. The price is certainly right at 'free'... I find it not as helpful when it comes to SQL performance tuning. I usually have to resort to SQL*Plus or other tools to run the more advanced performance tuning things such as SQL Trace.

Dan Hotka

author in Professional Services at McGraw-Hill (Computer Software, 1-10 employees)

Vetted Review

10 years of experience

View profile

SQL Developer, a tool for everyone

Rating: 10 out of 10

Incentivized

November 1, 2017

Use Cases and Deployment Scope

Oracle SQL Developer is used as primary SQL Development tool, across the whole organization. It's used for development using Oracle 11g and 12c database. It was also used to access IBM DB2 Database, before completely switching to Oracle DB. It's simple to use, for everyone, starting from developers to QA, to DBAs. Developers, QA, DBAs, Managers, everyone uses it, across the whole organization.

Pros

It's easy to use and has lots of inbuilt shortcuts, which can be customized as well.
Works with various DBs including IBM DB2.
Simple UI, with multiple tab support

Cons

When opening more than 5-6 connection tabs, it tends to freeze, even of a machine with latest hardware and 32 GB+ Memory.
The "Explain Plan" section of the query needs improvement. By default, it doesn't have CPU cost and partition details.
Error detail section can be improved.

Likelihood to Recommend

SQL Developer is a great tool when dealing with SQL Databases, like Oracle 11g, 12c or IBM DB2. For No-SQL databases, like MongoDB, this isn't appropriate.

Verified User

Engineer in Information Technology (Computer Software company, 51-200 employees)

Vetted Review

2 years of experience

Manages the giant with another giant

Rating: 9 out of 10

Incentivized

November 1, 2017

Use Cases and Deployment Scope

As a software developer, it is important to manage databases from a fast and reliable presentation. SQL Developer allow developers to quickly manage data on a par with project and development times. Not only that, but also gives you modeling and reporting tools that facilitate the documentation in the analysis and design phases.

Pros

Data modeling and reporting tools.
Create new databases for startups.
Simple data management, even in a complex environment like Oracle Database.

Cons

It works mainly for Oracle and does not work as easily with other databases like SQL Server.
Installation can be a problem if you are not used to Oracle installation process.

Likelihood to Recommend

If you are working with Oracle Database, SQL Developer is the way to go. If you go with other databases like SQL Server you could prefer SQL Management or Toad.

Miguel Angel Merino Vega

Analista de Sistemas in Information Technology at Consultor independiente de software (Computer Software, 1-10 employees)

Vetted Review

6 years of experience

View profile

Loading Reviews List....

SQL Developer Review

Rating: 9 out of 10

Incentivized

November 30, 2017

Use Cases and Deployment Scope

Pros

PL/SQL Development: the tool's strength really. SD supports code condensing, parentheses/brace matching, insites (popup windows with data object column names, etc).
I like the report feature...very easy to add your library of SQL to be run as reports. SD works with bind variables in your SQL well too.
The history feature is particularly nice. It's called SQL Recall and it saves quite a number of PL/SQL and SQL code you have been working with for near-future reference and recovery if needed.
The code snippets is very nice. Various functions and function details at your fingertips. Use a drag and drop operation to add to your code.

Cons

SQL Tuning. SD has explained plans but these could easily be improved upon using the latest features of the Oracle RDBMS.
More code templates. You can add your own but the tool seems to be lacking a bit when it comes to pre-existing code examples.
Smaller foot print. The thing is huge and somewhat slow.
Seems every time I get a newer SD, I also have to upgrade the Java environment as well. Would be nice if they picked a rev of Java and stuck to it.

Likelihood to Recommend

Dan Hotka

author in Professional Services at McGraw-Hill (Computer Software, 1-10 employees)

Vetted Review

10 years of experience

View profile