NetBeans vs. Oracle SQL Developer

NetBeans is extremely user friendly and easy to start developing complex applications. Adding and configuring external libraries is much simpler than in Eclipse. It is highly cost effective and most of the latest framework based libraries required are automatically downloaded to the projects. The overall tool is also light weight and consumes less memory as compared to other competitor tools.

Incentivized

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

• Debugging - Save time hunting down errors by stepping through the code to find the root of a problem.
• Refactoring - Easily rename classes and variables or make other structural changes using built-in refactoring tools.
• Service management - NetBeans integrates seamlessly with web application servers like Tomcat and GlassFish.
• Source control - Works well with Git and other version control tools.

• 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

• NetBeans [should] work smoothly with systems having less RAM. Systems with less RAM face trouble with NetBeans.
• File open history also requires improvement. Once NetBeans is restarted, all files are closed automatically and there is no shortcut to open last opened files.

Incentivized

• 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

We had already thought of changing to TOAD, but we decided to stick with Oracle SQL Developer until the end.

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

It works very smoothly as compared to other tools . The problem of restarting and reimporting the projects is not in the netbeans IDE . The front end development features are good . Netbeans connector is one of the best thing which enables us to deeply integrate netbeans IDE with google chrome browser

Incentivized

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

• By working on Netbeans I just learned one more tool and can teach others about it. One should learn every tool so that it might help someday if another editor is not available and you have to use different software for your work.
• Compiling code became easy as it is not a feature of normal text editors. Only IDE can do this.

Incentivized

• 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