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
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
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.
[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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
