Oracle Point, Oracle Life.

Oracle SQL Developer is a free and fully supported graphical toll for database development. Its latest version 1.5 offers multi-databases support, such as Oracle, SQL Server, Access and MySQL. Also, Timesten is default to be supported with this new version.

Similar to famous IDE Eclipse, oracle now provides an “extension development kit” to have more third party involved in extension development. In page of “oracle SQL Developer - Extensions Exchange”, you can find a list of available extensions for Oracle SQL Developer in different versions. On that list, there is only one extension available for the latest version of Oracle SQL Developer. That is OrindaBuild, which generate Java source code to run your PL/SQL procedures and functions or any SQL statement you give it.

Besides of this extension, I also tried out the following three extensions below, which is not noted to be available for the latest version of Oracle SQL Developer. The experimental result is satisfied and they all work with the latest version of Oracle SQL Developer.

1. Insider for SQL Developer
2. Error Lookup for SQL Developer
3. Oracle Data Miner PL/SQL Code Generator

Among above extensions, “Insider for SQL Developer” is my favorite one. Ignoring the resource consumption, “Insider for SQL Developer” offers real-time overall database activity in graphical view as shown in following figure. Even though this extension disables some commercial functions, it’s still very helpful for you to get run-time outlook of database activity.

Continued…

In response to comment, I’ve included screenshot for “Opening Inside View”. Please be noted that logging on with sysdba role might be necessary for using that.

Popularity: 12% [?]