It took a few months, but I finally start appreciating the Oracle SQL Developer developed by Oracle (The Project Formerly Known As Raptor). There are still some bugs, for instance with debugging through a firewall (hey, didn’t we have the same problem with JDeveloper?) and some features are missing, but […]
Many people have a dislike of Dbms_job. Setting the right parameters requires good knowledge of the input parameters and you probably need a calculator too! In Oracle 10g, a new package might make things easier.
Historically, when you wanted to connect to an Oracle database you could not get around downloading and installing a bulky Oracle client. Since 2 years already an alternative exists: Oracle Instant Client. This is the marketingname for a zipfile with all DLL’s necessary for connecting to an Oracle instance. The […]
It is not well-known how the Oracle built-in Soundex exactly works. This article explains the basics and also describes the Dutch variation of this algorithm.
At the end of january, Oracle announced that Oracle HTML DB was renamed to Oracle Application Express. At the same time they published a roadmap for the next year. This confirms the inside information I had that Oracle takes Application Express serious and keeps developing this development tool. Oracle Application […]
Last week I visited the Oaktable Seminar “Performance by Design” by Jonathan Lewis, held in Utrecht. I would like to share some of the topics of the seminar which I found particularly interesting.
Audience: DBAâ€™s, infrastructure architects. A brief explanation of the Oracle Dataguard and High Availability concepts.
The Adobe SVG Viewer is a viewer for Scalable Vector Graphics like charts and graphics and, as I found out, is used by Oracle in web-applications. It’s downloadable at Adobe downloads. However, the plugin only works for Internet Explorer. With some minor tweaks it’s possible to make it available under […]