IntelliJ IDEA vs. Oracle SQL Developer

IntelliJ IDEA

Oracle SQL Developer

Overview
Product	Rating	Most Used By	Product Summary	Starting Price
IntelliJ IDEA	Score 9.4 out of 10	N/A	IntelliJ IDEA is an IDE that aims to give Java and Kotlin developers everything they need out of the box, including a smart code editor, built-in developer tools, framework support, database support, web development support, and much more.	$19.90 per month
Oracle SQL Developer	Score 8.8 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

IntelliJ IDEA

Oracle SQL Developer

Editions & Modules

For Individual Use (Monthly billing): $19.90
per month
For Organizations (Monthly billing): $71.90
per month
For Individual Use (Yearly billing): $199
per year
For Organizations (Yearly billing): $719
per year

No answers on this topic

Offerings

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

Entry-level Setup Fee

No setup fee

Additional Details

All Products Pack (For Individual Use) – $299 /1st year, $ 239 /2nd year and $ 179 /3d year onwards All Products Pack (For Organizations) – $979 / year

—

More Pricing Information

Community Pulse
	IntelliJ IDEA	Oracle SQL Developer
Considered Both Products	IntelliJ IDEA Gaurav Gosavi Staff Software Engineer Chose IntelliJ IDEA In summary, IntelliJ is more polished and feature-rich out of the box, especially for Java development. Eclipse is extensible but can be rougher around the edges. IntelliJ costs money for advanced features, while Eclipse is free. IntelliJ offers many developers a better … Incentivized Helpful? Verified User Anonymous Chose IntelliJ IDEA Back in the day, there weren't too many PHP IDEs with proper syntax and code checks, but PHPStorm and IDEA worked great. So great that when I needed a Java IDE the next time, I gave it a go and have never looked back since (okay, I did keep checking the competition and … Incentivized Helpful? Animesh Kumar Senior Member of Technical Staff Chose IntelliJ IDEA IntelliJ stacks better against Eclipse or VS Code because it provides better code suggestions, out-of-the-box SonarLint integration, and built-in support for version control with git. It also has a vast collection of plugins that can increase developer productivity, reduce … Incentivized Helpful? Verified User Anonymous Chose IntelliJ IDEA IntelliJ IDEA is the most specific and oriented towards my line of work, however, after using it for years - it's also my preferred IDE that I use for personal projects as well. Jetbrains other IDE offerings are almost as good and I do use them from time to time but IntelliJ … Incentivized Helpful? Dushyant Pathak (DKP) Technology Analyst Chose IntelliJ IDEA IntelliJ IDEA has several benefits over VS Code when it comes to Java applications, including in-built Java compilers, Maven lifecycle support, Lombok preprocessing, and sonar integration. While VS Code is largely generic, IntelliJ IDEA has focused primarily on Java … Incentivized Helpful? Verified User Anonymous Chose IntelliJ IDEA Eclipse Incentivized Helpful? Verified User Anonymous Chose IntelliJ IDEA It is much more friendly to use and has more features in terms of leading to more efficient and productive software engineers. I prefer the interface as well as the code Completion/code refactoring and error suggestions Incentivized Helpful? LS Lakshita Salian Manager Chose IntelliJ IDEA Intellij is faster and smoother. SO it saves development time Incentivized Helpful? Verified User Anonymous Chose IntelliJ IDEA Eclipse, Microsoft Visual Studio Code and Notepad++ Incentivized Helpful? Verified User Anonymous Chose IntelliJ IDEA PyCharm is for Python, but otherwise similar to IntelliJ IDEA. Both IDEs are great for their intended languages. I selected Intellij IDEA because of its support for Scala. I selected Intellij IDEA over Spark SBT because it is faster and more convenient. Incentivized Helpful? Tung Vu Senior Software Engineer Chose IntelliJ IDEA Eclipse is just so old, like a dinosaur, compared to IntelliJ. There are still formats that Eclipse supports better, especially old and/or propriety ones. Still, most of the modern software development needs can be done on IntelliJ, & in a much better way, some of them are not … Incentivized Helpful? Nitin Gupta Salesforce/Apttus Developer Chose IntelliJ IDEA Previously we were using Eclipse but due to the ease of understanding and easy to navigate user interface with drop downs, wizards they are better in IntelliJ moreover for experienced developers migrating to IntelliJ as compared to Eclipse. It has an easy to understand UI and … Incentivized Helpful? Chris Barretto Engineering Manager Chose IntelliJ IDEA IntelliJ has the richest and most complete set of features out of all the IDEs I've tried. There is the most compatibility across different languages and caters to different compilation strategies. The updates come very regularly, so we know that the product is constantly … Incentivized Helpful? Verified User Anonymous Chose IntelliJ IDEA IntelliJ IDEA is one of the products of JetBrains and it beats every IDE in the market in terms of performance, user experience, and productivity. Incentivized Helpful? David Tanner Sr Software Engineer Chose IntelliJ IDEA Microsoft Visual Studio Code (VS) requires a lot of textual configuration, where IntelliJ IDEA provides a graphical interface with configuration options displayed. This matters a lot to me as I don't want to hunt around the internet to remember how to set different parameters … Incentivized Helpful? Tharsanan Kurukulasingam Software Engineer Chose IntelliJ IDEA UI--IntelliJ IDEA is the winner. IntelliSense--Again, IntelliJ IDEA is the winner. Performance and CPU usage - IntelliJ IDEA has a lot of room to improve on this. Eclipse handle the large projects more effectively than IntelliJ IDEA. Incentivized Helpful? Verified User Anonymous Chose IntelliJ IDEA IntelliJ IDEA includes FTP deployment which is ideal for legacy web applications and simple projects that don't use CI/CD. The outline view which lists methods within a class (ColdFusion component) is the easiest to use out of any other IDE and makes navigating large files a … Incentivized Helpful? A. Kıvanç Güler Senior Solution Engineer - Tanzu Chose IntelliJ IDEA Jdeveloper: So slow, crashes many time, leak Spring framework developer productivity support. Best performance with recommended Oracle SDK Distributions and not comparable in terms of debugging. Eclipse: More J2ee oriented cant act as Intellij IDEA cloud native development with … Incentivized Helpful? AJ Ashutosh Jha Student Chose IntelliJ IDEA Eclipse [doesn't] have smart suggestions feature, nor [does] it ha[ve] column selection mode. So, overall productivity decreases. Incentivized Helpful? Verified User Anonymous Chose IntelliJ IDEA IntelliJ is very much focused on user-friendliness which I'm very fond of. Incentivized Helpful? Verified User Anonymous Chose IntelliJ IDEA Much more functionality and freedom than in Eclipse, but it cost you money while the second is free. Incentivized Helpful? SN Sumanthkumar Nagamalli Technical consultant Chose IntelliJ IDEA I have used Eclipse also in the past. But it is slow compared to IntelliJ, it does not offer as many features as IntelliJ offers, and the integrations with third-party tools is not great. But they are open-source and they don't charge anything whereas IntelliJ charges $500 per … Incentivized Helpful? KV Kunal Verma Software Engineer Intern Chose IntelliJ IDEA They are memory friendly. The boot-up really fast as compared to IntelliJ IDE. Open-source and freely available to use is one of the major reasons if someone can switch from IntelliJ. Vast community support is available in case of any issue. They occupy less space as compared … Incentivized Helpful? Verified User Anonymous Chose IntelliJ IDEA IntelliJ is a full featured IDES and has the most advanced set of features for developing web and desktop applications. It supports integration of the Spring framework which is necessary for web development. It supports web app scripting languages and web development … Incentivized Helpful? Verified User Anonymous Chose IntelliJ IDEA Since we are primarily a Scala shop, I only evaluated other tools based on their support for Scala. As I hinted at before, Vim and Sublime Text 3 have practically no support for Scala as all the Scala plugins that worked were never finished and abandoned and only work for Scala … Incentivized Helpful?	Oracle SQL Developer DC Daniel Cheung Database Administrator Chose Oracle SQL Developer Oracle provides more functionality then toad freeware Incentivized Helpful? Verified User Anonymous Chose Oracle SQL Developer Oracle SQL Developer is easy to install, easy to use and navigate and feature rich graphical user interface to view and manage data. It can be used across various roles like developer, tester, administrator etc. It helps to develop a strong base for database understanding. … Incentivized Helpful? Verified User Anonymous Chose Oracle SQL Developer Oracle Big Data SQL Cloud Service and DbVisualizer 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 Anonymous 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 Anonymous 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? Satishbabu Gunukula, Oracle ACE Sr. Database Architect Chose Oracle SQL Developer Toad for Oracle Incentivized Helpful? Verified User Anonymous 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 Anonymous Chose Oracle SQL Developer MySQL Incentivized Helpful? Verified User Anonymous 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 Anonymous 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? Verified User Anonymous 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 Anonymous 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? 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? Kevin Chu Sr. App Developer Chose Oracle SQL Developer SQL Developer is a strong competitor. Incentivized Helpful? Verified User Anonymous Chose Oracle SQL Developer I have not used a product like Oracle SQL Developer before. Incentivized Helpful?

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

User Ratings
	IntelliJ IDEA	Oracle SQL Developer
Likelihood to Recommend	9.7 (0 ratings)	9.0 (0 ratings)
Likelihood to Renew	5.0 (0 ratings)	10.0 (0 ratings)
Usability	9.1 (0 ratings)	8.9 (0 ratings)
Support Rating	8.9 (0 ratings)	7.0 (0 ratings)
Implementation Rating	9.0 (0 ratings)	9.2 (0 ratings)

User Testimonials
	IntelliJ IDEA	Oracle SQL Developer
Likelihood to Recommend	IntelliJ IDEA is very well suited for developers working on Java, Javascript, and related technologies. It is the best IDE I've found so far for software development in Java. IntelliJ IDEA is specifically well suited for web software development using Java as it provides default configurations for web frameworks like Spring and Spring Boot. For other use cases, I feel it is more than good enough. Incentivized Animesh Kumar Senior Member of Technical Staff Read full review	[Oracle SQL Developer is] 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. Incentivized Binoy Shah Software Integration Tester Read full review
Pros	Compared to Eclipse, basically it is a easier to learn which results in faster learning curve. Good for small or mid-sized projects. Generally speaking developers can be productive in a short training and use. Very rich plug-in capability, such as out of the box support for version control systems. User friendly interface. Responsive and interactive than other IDE tools. Incentivized Verified User Anonymous Read full review	Export SQL results to a spreadsheet. After a query is run, you are able to export the results to a spreadsheet Easily preview data columns on an Oracle table or view and the metadata on those columns. SQL Editor is color-coded so that you can tell easily what are keywords. You can set up SQL code templates to be able to use shortcut keys to format your SQL query easily in a readable format that you prefer. Incentivized Verified User Anonymous Read full review
Cons	IntelliJ IDEA wins as long as the language is Java. Outside that , e.g., in other languages, it is not so advanced. It is licensed, with a steep licensing cost. All features are not included in the free edition. It is not as light as Eclipse, so in a weak system, it can be a pain. Incentivized Dhruba Jyoti Nag Associate Read full review	Setup can be challenging if your schemas aren't well formed or managed. Also, the ability to model/develop extensions for an existing database solution will depend on how robust the DBA provisioned roles and designed the respective schemas. Detailed analysis of models can be clunky for complex relational models. Incentivized Verified User Anonymous Read full review
Likelihood to Renew	VS Code is maturing and has a Scala plugin now. The overall experience with VS Code - for web development at least - is very snappy/fast. IntelliJ feels a bit sluggish in comparison. If that Scala plugin for VS Code is deemed mature enough - we may not bother renewing and resort to the Community Edition if we need it. Incentivized Verified User Anonymous Read full review	It allows most users to perform daily activities in a simple way, with no cost since the tool is free. Incentivized Lisandro Fernigrini Database Practice Lead Read full review
Usability	There is always room for improvement, but I haven't met any IDE that I liked more so far. Even if it did not fit a use case right out of the box, there is always a way to configure how it works to do just that. Incentivized Verified User Anonymous Read full review	Oracle SQL Developer is very easy to use and there are a wide range of courses available which can help you get started just within a day. Data can be exported in multiple formats based on user requirements. Organizational data can be stored and management effectively using Oracle SQL Developer. All the data, tables, sequences, indexes can be easily created and updated in Oracle SQL Developer. Incentivized Verified User Anonymous Read full review
Support Rating	Customer support is really good in the case of IntelliJ. If you are paying for this product then, the company makes sure that you will get all the services adequately. Regular update patches are provided to improve the IDE. An online bug report makes it easier for the developers to find the solution as fast as possible. The large online community also helps to find the various solutions to the issues. Incentivized KV Kunal Verma Software Engineer Intern Read full review	Large user community support Incentivized Verified User Anonymous Read full review
Implementation Rating	This installs just like any other application - its pretty straight forward. Perhaps licensing could be more challenging - but if you use the cloud licensing they offer its as simple as having engineers login to the application and it just works. Incentivized Verified User Anonymous Read full review	Just download and uncompress! Incentivized Lisandro Fernigrini Database Practice Lead Read full review
Alternatives Considered	In summary, IntelliJ is more polished and feature-rich out of the box, especially for Java development. Eclipse is extensible but can be rougher around the edges. IntelliJ costs money for advanced features, while Eclipse is free. IntelliJ offers many developers a better experience, but Eclipse remains a viable open-source alternative. Incentivized Gaurav Gosavi Staff Software Engineer Read full review	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 and develop Oracle Database in both on premise and Cloud deployments. SQL Developer can also connect and interact with non oracle database like MS SQL server and MySQL etc. Incentivized Joe He Lead Database Administrator Read full review
Return on Investment	Boosts productivity: IntelliJ IDEA is efficient to operate, and with its shortcuts and customization, the possibilities to improve your productivity are endless. Clean code: IntelliJ IDEA will catch or syntax errors, or even suggest a way something could be written better, or call our your duplicated code or unused imports. An easy learning curve for new guys: It's much easier to use than some of the competition, so it helps the new guys hit the ground running by being easy to operate and understand. Incentivized Verified User Anonymous Read full review	No impact on the organization's budget as Oracle SQL Developer is free. With the increased productivity of our database administrators, they are able to better assist the software developers in prototyping future products. Through Oracle SQL Developer, our administrators were able to normalize many of our databases, reducing the amount of redundancy, and hence increasing the performance of our main application. Incentivized Verified User Anonymous Read full review
ScreenShots	IntelliJ IDEA Screenshots