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

(489)

Attribute Ratings

Reviews

(1-1 of 1)
Companies can't remove reviews or game the system. Here's why
Lisandro Fernigrini | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
[Oracle] SQL Developer is a free to use IDE that allows to manage and use Oracle databases both on premise and in the cloud. We used it in the different development teams to design and develop Oracle databases, allowing to easily create tables, views, procedures and functions. We also used some of the features to troubleshoot or monitor small incidents (like performance bottleneck) in our development and testing environments.
  • 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
Almost all development activities (the tool is called "SQL Developer", not "DBA Toolset") can be done easily and quick with [Oracle] SQL Developer. From data model creation (tables, views) to development (creation of procedures, functions, packages) and then testing (SQL Developer includes an easy to use debugger), all tasks can be performed in a single tool.
It may not be as complete as other solutions for DBA tasks like instance monitoring, but it is usually OK for development and testing environments if you want to do some basic troubleshooting.
  • Really fast ROI, since the tool is 100% free.
  • Just needs to be downloaded and decompressed (no complex installation). You can have it working in 5 minutes!
  • Easily import previous versions configuration and connections, making upgrades really simple.
Having used both TOAD and PL/SQL Developer, I believe SQL Developer from Oracle is a most than acceptable alternative, maybe not as powerful and complete as them but being free has a very positive impact. Most development profiles can work perfectly using SQL Developer while specific admin task may require TOAD or other tools.
50
Almost all members of development teams, including
a) Architects (they define tables and views, perform code review of procedures and functions)
b) Developers (they define tables and views, create procedures and functions, insert configuration data)
c) Testers (they review table definitions, update configuration data, query database contents to verify scenarios / test cases)
1
No support is really required, I usually assist developers to configure / personalize the IDE when they find something they cannot do by themselves, but is not something frequent.
  • Allow Architects to define or review data model
  • Allow Developers to implement tables and views, and to develop procedures and functions
  • Allow Testers to verify test cases against the data processed
It allows most users to perform daily activities in a simple way, with no cost since the tool is free.
No
  • Price
  • Product Features
  • Product Usability
Being free allowed all users in the company to connect to Oracle databases, either to design, develop or test the software being developed.
  • Implemented in-house
No
Change management was minimal
Nothing at all! Just download the compressed software into a shared folder and ask users to copy and uncompress it on their computers. I usually downloaded the latest version every 3-4 months and notified users so they update their local versions (that is simple since it automatically offers to import configuration and connections from previous versions)
Just download and uncompress!
  • Slow queries are sometimes disappointing since may produce a disconnection from the Database
No
It is simple to install (just download and decompress, no extra steps) and very simple to configure database connections. Standard activities like table creations / change and development of procedures and functions is very simple.
Return to navigation