Easy data surfing
I use Oracle SQL Developer as an editor to run various queries and export data to my desired format as Excel or CSV files. I usually use …
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.
Recent 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
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.
Product Details
- About
- Competitors
- Tech Details
- FAQs
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 Competitors
SQL Developer Technical Details
| Deployment Types | Software as a Service (SaaS), Cloud, or Web-Based |
|---|---|
| Operating Systems | Unspecified |
| Mobile Application | No |
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.
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).
Comparisons
Compare with
Reviews and Ratings
(489)Attribute Ratings
Reviews
(1-4 of 4)Companies can't remove reviews or game the system. Here's why
December 21, 2023
Oracle SQL Developer - Free Rool
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
- 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
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.
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.
- DBMS_OUTPUT
- Export Data
- Import Data
- Create Objects
- Explain Plain
- SQL Tuning Advisor
No
[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
- 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
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)
- Slow queries are sometimes disappointing since may produce a disconnection from the Database
No
April 12, 2021
Must-have SQL editor
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 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
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
No
- Database querying
- Database exploration
- Data modeling
- Data management
- Data visualization
- Reporting
- Complex analysis
- Advanced analytics
No
October 08, 2019
SQL Developer is amazing!
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.
- 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
Not Sure
- Product Features
- Existing Relationship with the Vendor
- Analyst Reports
Either way I believe that we will go for the same app.
No
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.