Oracle SQL Developer

Oracle SQL Developer

Oracle SQL Developer

490 Reviews and Ratings

Overview
Product	Rating	Most Used By	Product Summary	Starting Price
SQL Developer	Score 7.6 out of 10	N/A	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.	N/A

Pricing

Oracle SQL Developer

Editions & Modules

No answers on this topic

Offerings

Pricing Offerings
SQL Developer
Free Trial
No
Free/Freemium Version
Yes
Premium Consulting/Integration Services
No

Entry-level Setup Fee

No setup fee

Additional Details

—

More Pricing Information

Community Pulse
	Oracle SQL Developer
Considered Both Products	SQL Developer Verified User Professional Chose Oracle SQL Developer 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. Incentivized Helpful? Verified User Employee Chose Oracle SQL Developer SQL Developer can be considered a light-weight version of Toad Data Point. It is missing the database federation capability but allows for more native integration with Oracle databases. Incentivized Helpful? Rohit Goyal Risk Analyst Chose Oracle SQL Developer Oracle SQL Developer has rich User interface and user friendly compared to other databases, it is also used In large applications which has huge data sets and need good performance that is only possible in Oracle Developer, It also gives us fast curd operations and better space … Incentivized Helpful? Lisandro Fernigrini Database Practice Lead Chose Oracle SQL Developer 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 … Incentivized Helpful? Joe He Lead Database Administrator Chose Oracle SQL Developer Oracle SQL Developer is available on multiple platforms, Windows Mac Linux and it's free. SQL Developer is best suited for a big cross functional globally based team. SQL Developer is less resource intensive, compared to other IDEs. SQL Developer has the capability to manage … Incentivized Helpful? Verified User Team Lead Chose Oracle SQL Developer [The] developer's user interface is very handy and simple to use. [W]e can see full query [executions] and optimize the query data import and export, [which] is very easy. [Easy] [installation] and setup [of the] debugging [process] is easy. Incentivized Helpful? Binoy Shah Software Integration Tester Chose Oracle SQL Developer [Oracle SQL Developer] is well suited when one doesn't need to work heavily on DB; a person who has just started learning SQL or working on SQL can work easily using SQL developer. It's free. Incentivized Helpful? Lee Luchs Senior Solutions Analytics Consultant Chose Oracle SQL Developer In addition to Oracle SQL Developer I have used Microsoft SQL Server management studio, Toad for Oracle, SAS, and other third party SQL tools. I have found Oracle SQL Developer to be one of the best all around tools for accessing Oracle databases, as well as interfacing with … Incentivized Helpful? Sushant goyal Analyst Chose Oracle SQL Developer Oracle SQL Developer is better than SQL server, as it is easy to set up and install. Oracle SQL Developer is better in UI than SQL server. The features are almost the same. In comparison to DBeaver, it is much easier to set up as DBeaver's installation and setup is very … Incentivized Helpful? Verified User Manager Chose Oracle SQL Developer 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 … Incentivized Helpful? Verified User Consultant Chose Oracle SQL Developer Toad from Dell is a licensed product. We are just using it for using queries using GUI, so SQL Developer was a good option for us. Incentivized Helpful? Balázs Kiss Software Developer Chose Oracle SQL Developer IDEA has a built-in database connection and query platform. It has a slightly better code completion feature but lacks many of the functions of the SQL developer. Incentivized Helpful? Ken Turner Oracle Database Administrator Chose Oracle SQL Developer This SQL Developer product stacks up well against TOAD, in that it has most of the functionality that TOAD has and allows better organization for me. It also allows me to make connections within new folders of the same database with different users. The best thing about SQL … Incentivized Helpful? Jatel Desai Programmer Analyst Chose Oracle SQL Developer Oracle SQL Developer, in comparison to Toad for Oracle, works very similarly. Toad for Oracle is very useful for complex data management, and this includes monitoring queries and managing permissions. Oracle SQL Developer is great as a simple tool for developers. It has … Incentivized Helpful? Verified User Employee Chose Oracle SQL Developer SQL Developer is a very simple tool that is user-friendly and easy to understand for beginners as well. As SQL Developer is Oracle's own product, the Oracle product support is better when it is mentioned about the use of SQL Developer in Service Requests. The area of … Incentivized Helpful? Zhann Goloborodko Senior Programmer/Analyst Chose Oracle SQL Developer DBArtisan is the elephant in the room for a number of reasons. It not only does everything SQL Developer does, but it also has a huge number of management functions built-in. However, it is immensely expensive and, for your average developer, way overkill. Squirrel is also a … Incentivized Helpful? CO Chris Oros IT Analyst Chose Oracle SQL Developer Oracle SQL Developer has a much simpler, novice-friendly interface than TOAD or Sequel Pro. Less clutter and fewer buttons makes it easier for a non-expert/non-DBA to navigate and query. Having a product supported by Oracle itself is also a draw. If an issue is being … Incentivized Helpful? Verified User Employee Chose Oracle SQL Developer Prior to using Oracle SQL Developer, I used Toad Data Point. I did not have any decision making in choosing Oracle SQL over Toad Data Point but I can say the ease of use is noticeable in Oracles SQL. Oracle is every bit as good if not better than Toad Data Point due to ease … Incentivized Helpful? Verified User Consultant Chose Oracle SQL Developer I used both SQL Developer and Oracle Enterprise Manager (OEM). SQL Developer does not stack up against OEM. They complement each other. Incentivized Helpful? Kevin Chu Sr. App Developer Chose Oracle SQL Developer SQL Developer is a strong competitor. Incentivized Helpful? Verified User Engineer Chose Oracle SQL Developer I have not used a product like Oracle SQL Developer before. Incentivized Helpful? Verified User Analyst Chose Oracle SQL Developer I believe SQL Developer is easier to use than TOAD is many ways and easier. Incentivized Helpful?
Top Pros	Pro Easy to use Pro User friendly Pro Oracle database
Top Cons	Minus Not stable Minus Not support Minus Auto completion

Best Alternatives
	Oracle SQL Developer
Small Businesses	PyCharm Score 9.0 out of 10
Medium-sized Companies	PyCharm Score 9.0 out of 10
Enterprises	PyCharm Score 9.0 out of 10
All Alternatives	View all alternatives

User Ratings
	Oracle SQL Developer
Likelihood to Recommend	7.5 (72 ratings)
Likelihood to Renew	10.0 (4 ratings)
Usability	8.2 (2 ratings)
Support Rating	7.0 (2 ratings)
Implementation Rating	9.2 (2 ratings)

User Testimonials
	Oracle SQL Developer
Likelihood to Recommend	Oracle 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. Incentivized Lisandro Fernigrini Database Practice Lead Read full review
Pros	Oracle 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. Incentivized Joe He Lead Database Administrator Read full review
Cons	Oracle Inability to run multiple queries on the same database. You can only run one query on a given database. Analytical models created from complex tables isn't accurate, and needs work. Inability to view multiple tables of a database side-by-side. When trying to find correlations between tables, it would help to be able to see them at once on the same page. Incentivized Verified User Anonymous Read full review
Likelihood to Renew	Oracle We had already thought of changing to TOAD, but we decided to stick with Oracle SQL Developer until the end. Incentivized Verified User Anonymous Read full review
Usability	Oracle 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. Incentivized Verified User Anonymous Read full review
Support Rating	Oracle Large user community support Incentivized Verified User Anonymous Read full review
Implementation Rating	Oracle Just download and uncompress! Incentivized Lisandro Fernigrini Database Practice Lead Read full review
Alternatives Considered	Oracle I have started to use Toad for Oracle recently because it is easier to sort and filter results, due to their memory sort feature that puts the results from your query in memory so that you don't have to rerun your query. I have used SQL Developer to easily update records in tables that I need to fix. I haven't found an easy way to do this in Toad other than writing SQL insert statements. Incentivized Verified User Anonymous Read full review
Return on Investment	Oracle It gives 100% return on investment as it is free of cost. No need to have multiple tools for each database Considering the employee training, so one can save money on training, as it is not very hard to use so still savings. Incentivized Binoy Shah Software Integration Tester Read full review
ScreenShots