In spite I’m an Oracle database expert I work also partly with Microsoft SQL Server and Sybase.
This gives me the opportunity to compare different RDBMSs and on the other hand identify weak areas in Oracle compared to others.
This article is about missing functionality or features that probably every Oracle DBA would like to have in the future Oracle database releases (Oracle Server 12c for example). And I’ll start with the database access control that is not so flexible on Oracle as in Microsoft SQL Server or Sybase. Read more »
I remember testing the Project Raptor software about 5 years ago, Oracle’s new graphical tool for creating and browsing database objects. With a few clicks you could easily create and debug stored procedures, test SQL statements and view optimizer plans. Raptor was small, fast, and fun, and perhaps best of all, it was FREE! Later, the SQL Developer production version 1.0 was released in 2006.
Right from the beginning the tool was supported by Oracle Support for any customer with a current Oracle Database support contract. I admit I did not use SQL Developer right from the beginning. With more features coming into the new releases I started slowly accommodating them in my DBA toolset. So what’s now? Is it still small, fast and fun? Read below my short software review of the current SQL Developer version 126.96.36.199. Read more »