NetBeans is a free and open source platform and integrated development environment (IDE).
N/A
SQL Developer
Score 7.7 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.
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.
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.
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.
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.
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.
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.
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.
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.
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
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.
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.
