Skip to main content
TrustRadius

Overview

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

Read more
Recent Reviews

TrustRadius Insights

Seamless Integration: Users have consistently praised the seamless integration of Oracle SQL Developer with all versions of Oracle …
Continue reading

Must-have SQL editor

7 out of 10
April 12, 2021
Incentivized
Oracle SQL Developer is used across the company by different users depending on their preferences. Since it’s free, anyone can download …
Continue reading

SQL Developer Review

9 out of 10
December 13, 2019
Incentivized
We use SQL Developer in our IT organization as well as in our functional side of the organization as well. It solves our issues for …
Continue reading
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Reviewer Pros & Cons

View all pros & cons
Return to navigation

Pricing

View all pricing
N/A
Unavailable

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

Entry-level set up fee?

  • No setup fee

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services

Would you like us to let the vendor know that you want pricing?

8 people also want pricing

Alternatives Pricing

What is Rider?

JetBrains supports .NET development with Rider, a .NET IDE based on the IntelliJ platform and ReSharper.

What is The Welkin Suite?

The Welkin Suite offers an integrated development environment with 105 features (and growing). The vendor aims to help you automate the chores of development, and therefore enhance your coding velocity and increase the quality of your deliverable code.

Return to navigation

Product Details

What is 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

Deployment TypesSoftware as a Service (SaaS), Cloud, or Web-Based
Operating SystemsUnspecified
Mobile ApplicationNo

Frequently Asked Questions

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.

Microsoft SQL Server, Microsoft Access, and DBeaver are common alternatives for SQL Developer.

Reviewers rate Oracle University Experience highest, with a score of 7.9.

The most common users of SQL Developer are from Enterprises (1,001+ employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(489)

Community Insights

TrustRadius Insights are summaries of user sentiment data from TrustRadius reviews and, when necessary, 3rd-party data sources. Have feedback on this content? Let us know!

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.

Crashes and Stability Issues: Users have reported constant unexplained crashes and overall instability during long query executions. These performance issues under heavy usage has prompted users to call for updates to enhance stability and reliability.

Lack of Documentation and Feature Limitations: Reviewers have expressed frustration over the lack of documentation for using features effectively, inability to extend the tool for custom plugins, missing database design tools, and absence of help for legacy commands. They emphasize the need for comprehensive documentation within the software.

Performance Problems and Inefficiencies: Users mention higher RAM usage causing slowness for big queries, automatic disconnection from the database when idle impacting workflow, absence of auto-completion for queries affecting efficiency, inconsistent functionality of re-connection option after a database disconnection, and tool's heavy system memory usage. They seek improved performance, more efficient workflows, and better resource management functionalities.

Attribute Ratings

Reviews

(1-25 of 72)
Companies can't remove reviews or game the system. Here's why
Score 6 out of 10
Vetted Review
Verified User
Incentivized
  • It has allowed for very seamless integration with all versions of Oracle databases without the need for complicated setup.
  • It has a very easy set-up and installation process and has maintained cross-OS compatibility exceptionally well.
  • It allows for native Oracle SQL database features integration.
  • There are constant unexplained crashes that are not particularly well explained.
  • There is very little documentation about how to use features.
  • there seems to be no way to extend the tool for custom plugins.
Ankur Karmakar | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
  • 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
  • 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
Score 8 out of 10
Vetted Review
Verified User
Incentivized
  • The efficient connectivity with various Oracle and relational databases.
  • The options for fastest query building and execution. The debugging options also displays exact error message of the query, if any bug in query.
  • We can export extracted data in various file formats.
  • Simple user interface and effective functions for user friendliness.
  • When the connected database is disconnected due to some issues, the re-connection option does not work properly all the time.
  • For the long time executions, tool gets unstable state.
  • The report and documentation features need to updated.
Lisandro Fernigrini | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • Ability to browse across all database components and easily modify or drop them, or create new ones.
  • Very simple to use and learn, yet includes many personalization options (like snippets and SQL history)
  • You can define window border colors for different connections, thus easily identifying production or sensitive environments at glance!
  • Import and Export data in a very simple way
  • Being a JAVA application, response times are sometimes not as good as native applications
  • Sometimes it uses more RAM than expected
  • Sometimes gets disconnected from DB
Joe He | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • Object Browser in SQL Developer allows you to explore the contents of your database using the connection tree.
  • The SQL Worksheet is an editor that allows for execution of SQL statements, scripts, and PL/SQL anonymous blocks. SELECT statements can be executed to return results in a spreadsheet-like 'grid' or can be executed as a script such to emulate SQL*Plus behavior and output
  • DBA Console allows users with administrative privileges to access DBA features such as database init file configuration, RMAN backup, storage, etc.
  • Showing more detail on real-time database performance data
  • Integration with AWR report
  • Show more diagnostic info on Oracle RAC
Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • [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.
  • [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.
April 27, 2021

Easiest SQL IDE

Binoy Shah | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Incentivized
  • Very simple UI. Also quite user friendly.
  • Debugging seems very easy if there is any issue.
  • It's a freeware and easy to install.
  • Also does support to connect with various kinds of databases.
  • When usage is really heavy, it lags a lot.
  • It automatically gets disconnected if haven't used for some amount of time.
  • Needs more detailed documentation.
Lee Luchs | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • Easy interface with large selection of useful utilities.
  • Import and export of pre-configured SQL connections for easy duplication.
  • Snippets, history, and other utilities add quick custom functionality.
  • Some database design tools found in other SQL tools are not yet available.
  • Customizing utility windows does not save after restarting application.
Sushant goyal | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
  • 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.
  • 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.
April 12, 2021

Must-have SQL editor

Score 7 out of 10
Vetted Review
Verified User
Incentivized
  • 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
  • Better user interface
  • Native support for other databases
  • Autocompletion
  • Performance
Satishbabu Gunukula, Oracle ACE | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Incentivized
  • Build and analyze SQL queries by connecting multiple databases.
  • User friendly GUI and easy to navigate through various features easily.
  • Import data easily from text files, Excel files, and CSV files.
  • Easy to install and config.
  • It uses lot of system memory.
  • Lack of scheduling jobs.
  • Export or import data from on-prem to cloud and vice versa easily.
  • Nice to have drag and [desktop] feature.
December 13, 2019

SQL Developer Review

Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • Ease of writing SQL queries and fine tuning it.
  • Very intuitive GUI.
  • It's a very heavy tool, and it doesn't work well with low memory computers.
  • It's doesn't show users the TNS entries for databases.
December 09, 2019

SQL Developer FOC

Ken Turner | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
  • DML and DDL.
  • Organization of connections to databases.
  • Export and import of external data.
  • SQL Developer does most everything TOAD can do.
  • Easier way to manipulate packages and procedures.
  • Better documentation and location of documentation easier to find online.
  • Maybe a little better look and feel to the GUI.
December 04, 2019

SQL Developer Review

Score 10 out of 10
Vetted Review
Verified User
Incentivized
  • Extract DDL for tables and indexes.
  • Provide statistical information from the data dictionary in an easy manner.
  • Help interface for command syntax is good when it works.
  • Help for legacy commands from SQL Plus- Some commands are deprecated but there is no explanation for what type of syntax to use instead.
  • Ability to start SQL Developer command line in the directory from which the command was launched (instead of SQL Developer home).
  • Spool without control characters.
Jatel Desai | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • Oracle SQL Developer's navigation bar has a lot of useful tools. When first learning how to use this product, it was very easy to move around and figure out what needed to be done.
  • This product allows you to organize schemas on a side bar view, which is very useful when working with multiple databases.
  • You can customize schema names to your liking, it does not have to be the same as others on the team.
  • Oracle SQL Developer is not the best tool for extracting data. If you want an excel sheet for all the outputted result data, it can take a very long time. This is tough for business users.
  • This tool does not allow you to monitor a system that is running as easy as other products similar to it.
  • Oracle SQL Developer is not as advanced in functionality as some other tools. For basic developers, this tool gets the job done. For more complex database management, I would suggest other software.
November 16, 2019

SQL developer for dummies

Score 6 out of 10
Vetted Review
Verified User
Incentivized
  • SQL Developer is easy to navigate and open database structures like tables, packages, procedures, etc.
  • Easy to connect to set up database connectivity using service name/SID information.
  • SQL Developer UI is very simple to understand and operate by the users and has a quick connect and load time of applications.
  • Easy to check the Explain plan assessing the cost of the SQL queries and thus helping in tuning.
  • Lacks the advanced options for a professional developer like accessing the dependent objects of a particular database object like Indexes, triggers, etc.
  • Lacks features do not have the SQL session monitoring capability and managing other Oracle sessions.
  • It does not give a clear indication of query status, whether it is running or stuck.
Zhann Goloborodko | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Incentivized
  • Build and analyze SQL.
  • Extract DDL.
  • Provides a quick overview of the Schema Structure.
  • Clunky, could use some basic UI improvements.
  • Returns only 100 lines at a time when querying DB.
  • Basic Oracle management functionality would be nice (check sizes of tablespaces, etc).
November 08, 2019

Great for non-DBA users

Score 8 out of 10
Vetted Review
Verified User
Incentivized
  • SQL Developer is useful for navigating the DDL of a table.
  • Easy-to-understand errors and explanations on incorrect queries.
  • Quick load time of application from start-up.
  • Explain plans are very helpful in tuning.
  • Never know when a query has been truly terminated. Even if one has access to the SQL Monitoring or Monitoring SQL Sessions, it still may show as being terminated but in actuality, within OEM, the query could still be running and need to be killed there. The inability to truly know when a session has ended results in frustration because the next query may not be able to run because the last is actually still running.
  • The tuning advisor runs very long and is not always helpful.
  • Not knowing the status of a query can be frustrating. That is, if a query is running long, it may show as "running" (i.e. the horizontal bar moving back and forth at the bottom of the screen), but in actuality, it may be hung up.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
  • Searches for and gathers data quickly and efficiently.
  • If you error during writing your queries, this usually provides accurate reasons why your query errored, allowing you to quickly make the correct fixes.
  • Allows for customization.
  • I am stretching to come up with cons for SQL Developer, it could possibly have more tips and tricks for easily writing queries. Maybe more user-friendly functionality.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
  • DBA section: automatic undo management, initialization parameters, database feature usage, instance viewer (CPU, session, top SQL, processes,etc.).
  • Memory/storage: beautiful graphics, performance, backup/recovery, security (roles, users, profiles, and auditing). All is nicely displayed!
  • SQL Worksheet: I can run queries in a database, hop to a different database, run the same query or different one. All can be done in one console.
  • I have connections set up for 40 databases, switch between databases - very convenient. Queries can be kept in History or save to a notepad.
  • Tools: 1.Modeling is a nice addition in SQL Developer. I don't use it for creating logical models. However, I find it very helpful to look at the model and understand the relationship between tables and schemas.
  • Database copy: make a copy of the database from source to destination with many different options - object copy, tablespace copy, schema copy, copy DDL, copy data.
  • Database diff: make comparisons between databases
  • Database export with many options based on requirements.
  • SQL Worksheet: listed above
  • Session monitoring: who is logged in.
  • Real-time SQL monitoring: insight into how to tune a poorly written query. It does, however, need an additional license.
  • General: tables are nicely displayed. I used it every day. I can see column, data model, constraints, grants, statistics, triggers, dependencies, partitions, indexes and I can generate SQL DDL!
  • A dashboard to display database status: all database connected/registered, general info, database up/down, version, size and which server it's on.
  • Schedule jobs to be run.
Return to navigation