NetBeans vs. Oracle SQL Developer

If your organization works with developing or supporting Java applications and is focused on running efficiently with a lean budget, NetBeans would be a good choice to consider.

If your development staff uses other languages, or prefers a high level of available professional IDE support, it may be better to consider a paid option if your budget allows.

[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

• Great code completion, just start typing some code and the program will fill in the code.
• Find/Replace is a key feature and works through whole projects as opposed to just a single file.
• Side by side code comparison right in the interface allows me to update similar pages.
• I appreciate the ease of using variable highlighting, with a wave of the mouse you can see visually where a given variable exists in your code.

Incentivized

• 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

• Heavy software needs more RAM. It does tend to use a lot of your computer's resources if you're loading up a huge project and slow things down.
• Problems with configuring plugins.
• With every release of a new version, there are some bugs which create problems while coding.

Incentivized

• 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

It allows most users to perform daily activities in a simple way, with no cost since the tool is free.

Incentivized

Netbeans enhances my coding work, shows me where I have errors and helps find variable instances. I would be lost without find/replace in projects functionality as I use projects as templates for new projects. Occasionally the code hints aggravate me, but I understand that it is actually making me a better coder, working to get the 'green light' of a clean file with no errors or clumsy code.

Incentivized

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

NetBeans has a very strong user community. We can find solutions here for almost all the problems we face. In addition, we can forward NetBeans Support teams the problems we cannot solve. We can get quick feedback from the support teams, but I generally try to solve my problems by following the forums.

Incentivized

Large user community support

Incentivized

Just download and uncompress!

Incentivized

IBM Rational Application Developer and IntelliJ IDEA are great with hell lot of features packed into the product and are subscription based. However, most of the features they were providing were moot from my organization's business perspective and the cost was expensive. Eclipse is an opensource product with great features, but is difficult to configure and use as compared to NetBeans. One of the frustrating issues we faced with Eclipse was its slowness while saving a file. http://https//stackoverflow.com/questions/40166270/eclipse-neon-pathetically-slow

Incentivized

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

• It changed my way of coding. In my early days of development I never indented code, but with NetBeans my coding way has changed.
• One IDE for all languages. I can write code in PHP, HTML, CSS, and JavaScript in only one editor or IDE.

Incentivized

• 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