Skip to main content
TrustRadius
SQL Developer

SQL Developer

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

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?

7 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

(491)

Attribute Ratings

Reviews

(1-3 of 3)
Companies can't remove reviews or game the system. Here's why
Score 7 out of 10
Vetted Review
Verified User
Incentivized
We utilize SQL Developer as the IDE tool to connect to the Oracle Database, although we don't employ all of its functionalities. Our primary use of this tool is to retrieve SQL queries and debug packages. The entire object structure is managed in a GitLab repository, and all scripts are executed using VS Code.
  • Structure Oracle Database objects
  • Intuitive navigation
  • Export Data
  • Java dependency
  • Autocomplete issues
Oracle SQL Developer is a free tool for accessing Oracle Database, and I don't see any significant limitations except, perhaps, for DBAs who may have specific requirements.
  • The only positive impact is that is free
  • It's hard to get used it when you worked with TOAD or PL/Developer for years before.
They do almost the same things, but I particularly I prefer TOAD, maybe because when I started programming with Oracle Database it was the first tool that I used and I think it's easier to use too.
5
We're a team of five developers, including the boss who manages all the schemas. We typically use SQL Developer to browse objects, retrieve and export data, and for debugging PL/SQL blocks. Additionally, it's convenient for maintaining and saving all schema passwords in one place. We can even export the connection properties.
5
Currently, our team consists of 5 members. While I hold some Oracle certifications, two members of my team are particularly experienced users without any certifications. However, the majority of the scripting or managing tasks is performed using scripts that we run on VS Code. We are proactive in keeping up with the latest versions, and we specifically choose Oracle SQL Developer because it is developed by Oracle itself, ensuring reliability as it is not third-party software.
  • Querying and Data Retrieval
  • PL/SQL Development and Debugging
  • Database Object Browsing and Management
  • N/A
  • We're going to continue using it as we are right now
We had already thought of changing to TOAD, but we decided to stick with Oracle SQL Developer until the end.
No
  • Ease of Use
  • Other
Oracle SQL Developer is not a software that we purchase, it is free.
I don't believe we would change anything. As usual, we seek insights from industry experts and incorporate a comprehensive cost-benefit analysis.
  • Implemented in-house
No
  • N/A
I have never contacted support for this product. (I can't skip the question)
I have never contacted support for this product.
No
I don't recall ever contacting Oracle support for this product. Typically, I am someone who likes to report issues, but I don't remember doing so. Most of the time, I visit the forum, and someone from Oracle usually answers my questions, which is generally satisfactory. I have no complaints.
At times, Oracle SQL Developer may experience freezing issues. However, despite this occasional inconvenience, the tool offers valuable features such as the ability to integrate plugins like utPLSQL, which greatly assists in debugging and testing our packages. Additionally, the usage of breakpoints and the flexibility to format text according to individual configurations enhance the debugging process.
  • DBMS_OUTPUT
  • Export Data
  • Import Data
  • Create Objects
  • Explain Plain
  • SQL Tuning Advisor
No
April 12, 2021

Must-have SQL editor

Score 7 out of 10
Vetted Review
Verified User
Incentivized
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.
  • 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
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.
  • It’s completely free
  • Improved developers for better efficiency
  • Can save time on querying and data modeling
  • Better data management
  • No need to have multiple tools for each database
Oracle SQL Developer is neck and neck with other tools. It offers all the required features and is much more reliable than many other vendors. Since it’s developed by Oracle, it works well with Oracle. It’s ultimately down to individual selection but Oracle SQL Developer offers a lot of features and it’s hard to think about other tools.
Technical and business side who need access to databases . They are from IT, BI, marketing, and finance groups.
5
We have a dedicated IT team that manages all software within the company.
  • Database querying
  • Data management
  • Database exploration
  • Using with Teradata
  • Using it for big data management
It is free to use and enterprise grade.
No
  • Price
  • Product Features
  • Product Usability
  • Product Reputation
  • Prior Experience with the Product
Free and extremely usable with lot of features
  • Don't know
No
No, it doesn’t have premium support but has large user community forums online
Large user community support
No
  • Database querying
  • Database exploration
  • Data modeling
  • Data management
  • Data visualization
  • Reporting
  • Complex analysis
  • Advanced analytics
No
It has lot of features that are required in SQL editor. It does the job well and is reliable. It is user friendly, integrates with different databases, and can be used for advanced database management activities.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We use Oracle SQL Developer to extract, create database objects such as views, stored procedures, packages, etc and to also report out info. We use it in the IT department. I find it to be a generally good tool.
  • Run queries
  • Export Data
  • When displaying errors it locates the error on the exact line and position.
  • I would like to drag and drop from and to any of the areas.
  • I would like to have more capabilities to export.
  • Have help info handy when I have a doubt with extensive help.
Oracle SQL developer is well suited to run quick reports or to extract quick info and create or change objects, but I would think is less appropriate when using it everyday to report when another tool should be used.
  • Positive - Lots of quick and easy reports.
  • Negative - Too much dependency.
I believe SQL Developer is easier to use than TOAD is many ways and easier.
4
Business Analyst use SQL developer in my organization to develop queries, export the output to Excel and deliver those spreadsheets to customers.
4
It is being used for SQL query development. Quick query to the database. Data extraction using SQL queries and exporting the results to Excel spreadsheets.
  • Querying
  • Asking the DB
  • Checking DB connections
  • Testing DB connections
  • I really like the multiple choices in the app such as browsing
  • Keep track of your multiple output
  • Check your SQL script prior to running it.
  • N/A
Because is still lacking many other functionalities that may help the user
Not Sure
  • Product Features
  • Existing Relationship with the Vendor
  • Analyst Reports
Either way I believe that we will go for the same app.
No
Oracle support is good. In general a get good and quick answers to my questions.
No
There has been more that one time. They are usually very responsive and it does not take long for them to come back to me.
Return to navigation