SQL Developer Reviews

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
434 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.2 out of 100

Do you work for this company? Manage this listing

TrustRadius Top Rated for 2019

Overall Rating

Reviewer's Company Size

Last Updated

By Topic

Industry

Department

Experience

Job Type

Role

Reviews (51-62 of 62)

Miguel Angel Merino Vega | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
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.
  • Data modeling and reporting tools.
  • Create new databases for startups.
  • Simple data management, even in a complex environment like Oracle Database.
  • 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.
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.
Read Miguel Angel Merino Vega's full review
Gurcan Orhan | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
  • Oracle SQL Developer can connect to many different database management systems, such as Postgres SQL, Enterprise DB, Microsoft SQL Server, etc.
  • Enhanced capabilities for querying
  • Ease of usage and simple UI
  • Importing Excel files to database quickly
  • Multiple query editor screens
  • Works both on Macs and Windows PCs and laptops
  • Enhanced formatting capabilities including your own query formatting
  • Comparison of saved queries and / or databases
  • Works with Data Modeler seamlesly
  • Enhanced debugging mode with break points
  • Change management support
  • Data miner support
  • OLAP support
  • REST Data services support
  • Cloud ready
  • History of SQL Statements
  • Thumbnail view
  • Git support
  • SVN support including team versioning environment
  • External tools support
  • Localization support
  • Customizable shortcuts
  • Fully customizable querying tool
  • Code Templates (can be used for commonly used statement: scf ==> select count(*) from)
  • Data and/or objects migration
  • Connection to multiple and various types of databases at once, within the same application
  • Works with files easily, steadily and with high performance
  • Mac and Windows support
  • Team coding support (git, SVN, etc.) with change management
  • Oracle special packages and additional tools (data miner, OLAP, Data Modeler, REST Data Services, Cloud and others)
  • Code templates. Shorten your most used statements (type ssf and "space" and it converts to "select * from")
  • Native JDBC support (with native connection string) for non-supported JDBC database connections.
  • Easy to install, just extract the zip file or copy your installation folder to a USB drive and it is ready to go.
  • Easy upgrades, without losing any connection details.
  • Supports CLI (Command Line Interface) for low level tasks.
Read Gurcan Orhan's full review
Luigi Vecchione | TrustRadius Reviewer
January 31, 2018

Why Should i Trust SQL?

Score 10 out of 10
Vetted Review
Verified User
Review Source
SQL Dev is being used in different projects since I'm working for a Consultant Company, it's totally related to the project requirements. It's so helpful to manage and query all the DWH instances and the database themselves.
  • Great Activity Monitoring
  • Great Management of Databases and Objects on the instance
  • Great Query Optimization module
  • Machine Learning Functionalities
  • Auto-format of the code
  • Resource Management
Well suited for management of dwh both in small than in big sizes. Not really suitable for Big Data Management.
Read Luigi Vecchione's full review
Paolo Borghi | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
I work in a consultancy company, which is specialized on SAP and Oracle, even if these aren't its only businesses. I work in the Oracle practice, and I've used Oracle SQL Developer since the first day I've been in my organization. Through this tool I've been able to solve a lot of "business problems", thanks to its ease of connection with many database technologies. Moreover, thanks to the many extensions that have been developed for it by Oracle and third parties, it has a great flexibility and a huge variety of tools that can be used for any purpose.
  • It's a free Oracle tool, that comes with Oracle Database
  • It allows the access to many database technologies, even if is specialized with Oracle
  • It has many add-ons, released by Oracle or by third parties, but supported by Oracle
  • It grants access to practically all the features of Oracle and similar database (i.e.: object development and management, SQL worksheet, DBA controls, database utilities, modeling and migration)
  • For its basic functionalities (i.e.: database object access) is really intuitive
  • Being an Oracle product, if you're working on Oracle Database, you can be sure to have full support on any kind of bug or malfunction from Oracle itself
  • It doesn't require being installed, but it's enough to copy its folder on an operating system
  • DBA utilities, such as resource manager and storage, are not really intuitive and may be improved
  • The graphical interface may be more intuitive and captivating: current one is quite rough, due to the low product maturity, being it a quite young product (first release in 2006)
  • It would be nice to integrate SQL Developer with Enterprise Manager, which is the main Oracle tool for db monitoring and administration
Whenever you're developing on an Oracle Database, SQL Developer is well suited. [Well suited] For creation of E-R models, schemas, database monitoring and administration or simple relational structure enquiring. To help with these tasks, you can improve your experience with this software by coupling it with other add-ons, like SQL Developer Data Modeler or other tools with specific functionalities. SQL Developer is not invasive since it doesn't require being installed. You just need to copy its files to a folder (both on a local computer or on remote) and, as you have the client for database connection, you're done. But, above all, it's a free tool! You or your organization don't have to pay anything to use it. You just have to download it from the Oracle website (like 400 Mb) and you're ready to start your work.
Read Paolo Borghi's full review
Veera Sadayappan | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source
SQL Developer is being used to access Oracle DB - SQL, PL/SQL, Procedure, etc. SQL developer is a free tool with Oracle Client to access Oracle DB. We use it as a SQL query tool for all DB.
  • Thin Java client.
  • Easy to use.
  • Integrates with Oracle DB well.
  • Easy for beginners.
  • Quick to access.
  • Good formatting options.
  • Thin Java client is sometime clunky.
  • Export Data is cumbersome.
  • Modifying query results.
SQL Developer integrates well with Oracle DB. It's good for beginners, but not as good for advanced querying. It can be some time very slow. Needs a little bit more work.
Read Veera Sadayappan's full review
Robby Tabuchi | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
SQL Developer is used by the Information Services Department as well as the Prospect Development Team. We use this software to leverage our extensive database. We have a large number of tables in our database that need to readily accessed. SQL Developer enables our teams to effectively query our database in real time.
  • Enables our team to quickly and effectively access information from our database.
  • Produces an easily readable view of the SQL scripts being written with debugging suggestions clearly marked. This helps with writing scripts in real time. I am able to see exactly where my script is creating an error.
  • SQL Developer auto completes table names, commands, functions, and field names. This is very helpful when trying to quickly write SQL script.
  • The interface is easy to navigate between input and output.
  • Encrypted connection to the database can be a little difficult especially when you have multiple database instances required for development and production.
  • The interface can be made to be a bit more user-friendly in terms of troubleshooting and suggestions for better utilization of the software.
  • Default settings should be easier to set such as keeping the line numbers in view at all times.
SQL Devloper is well suited for querying very extensive databases. This software allows you to explore and access large amounts of information very quickly. The user can leverage important information from many different tables of data. It is quite easy to create and execute complex code scripts to access very specific data. The software enables the user to review and debug the sql language very easily. SQL developer can also be used to quickly input data. This software has a medium difficult learning curve and requires sql writing training prior to use.
Read Robby Tabuchi's full review
Advait Deshpande | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
We use SQL Developer to connect and store databases for all our environments. All tables, stored procedures, functions, and triggers are managed using SQL Developer. Since we deal with OBIEE, our code primarily consists of PL-SQL supported by Oracle and hence SQL Developer works best for us.
  • Connecting to databases. Segregation of various connections.
  • Easy availability of the tool. No cost or licensing involved.
  • Display of compiler errors.
  • It becomes slower when dealing with large volumes of code.
  • Sometimes the connectivity is lost if the network/domain is changed. It needs to be more powerful.
  • I think more detailed explanation of error logs needs to be present. It helps in debugging of code.
For PL-SQL procedures and functions, SQL Developer is best suited and highly recommended.
Read Advait Deshpande's full review
Brian Martino | TrustRadius Reviewer
Score 1 out of 10
Vetted Review
Verified User
Review Source
SQL Developer is not directly used by my organization and for good reason. We are, however, forced to use it when we connect to our customer's networks and they sometimes have this as the only software available. This software allows us to connect to their various databases.
  • Easy installation. It is very simple to install SQL Developer.
  • Database connections. It is very simple to connect to a database using SQL Developer.
  • Speed of access. It is very quick to obtain a database connection using SQL Developer.
  • Viewing LOBs. SQL Developer does not support viewing large object types well.
  • Nested result sets. SQL Developer does not support showing data from REF CURSOR's or inline nested results.
  • Slow performance. SQL Developer is slow in general compared to other tools in this space I have used.
Only when nothing else is available do we use SQL Developer.
Read Brian Martino's full review
Anonymous | TrustRadius Reviewer
Score 6 out of 10
Vetted Review
Verified User
Review Source
We use SQL developer in our dev shop to access our database tables. It is the default product being used by the DBAs across our organization as well. Its a handy tool, that's freely available and can access non-Oracle databases as well.
  • It can be downloaded and used for free from the internet.
  • It is very useful in formatting SQL queries into Java code and vice versa.
  • It can be used for DML operations like, inserting, updating and deleting data as well.
  • It is a very resource intensive application and hogs the RAM and CPU cycles quite a bit.
  • It does not offer very easy integration with non-Oracle databases like IBM DB2 or SQL Server.
Its ideal for basic database operations like viewing some records, checking the SQL DDL for the tables defined. Also you can perform CRUD operations by just point and click technique.
Read this authenticated review
Anonymous | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
SQL Developer is being used within IT to control our databases. It's used to run queries, create reports, database administration, and for data modeling. Oracle is our ERP and SQL Developer is pretty much the easiest way to make changes to and get information out of our databases.
  • Run SQL statements and SQL scripts.
  • Create and save custom reports.
  • Cant really terminate an executing PL/SQL procedure once it has been started.
  • Export function can be buggy at times.
SQL Developer is well suited to create reports that are not readily available as a seeded report. It also makes it easy to make changes to seeded reports (adding/removing columns, calculated columns). Database monitoring as well as connecting to third party databases for monitoring is also simple. The tree based object browser makes it easy to navigate where you want to go.
Read this authenticated review
Anonymous | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
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.
  • 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
  • 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.
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.
Read this authenticated review
Anonymous | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source
We like using SQL Developer as redundancy wastes space in terms of memory and leads to larger spreadsheets. When more memory gets used, it inevitably will cost the organization more money, take longer to open and close files, and larger spreadsheets lead to more time fixing errors when mistakes or adjustments occur. Other than these issues, a main concern is that the data will be inconsistent with spelling and other detailing errors.
  • Ease of use, as the way it is viewed is much easier than other programs
  • SQL prompting that adapts to what the user may want going forward
  • Good ER diagrams that are easy to build and update
  • Easy exporting and importing techniques
  • User prompts that have vague message boxes can occur
  • Larger buttons to view options and selection areas much easier
  • Better heading ribbon to create easier navigation throughout the file
SQL Developer allows coders to take a business task and create an easy to read end product. Building views for consumer data, creating new tables with relevant information, and importing lots of data.

SQL Developer does not allow for the maximum scaling and dependent on add-ons.
Read this authenticated review

About SQL Developer

Oracle SQL Developer is an integrated development environment (IDE) which provides editors for working with SQL, PL/SQL, Stored Java Procedures, and XML in Oracle databases.

SQL Developer Technical Details

Operating Systems: Unspecified
Mobile Application:No