Oracle Magazine January-February 2012 online versions

| Feb 6, 2012
Oracle Magazine January-February 2012:
Flash version
HTML version

TIOBE Programming Community Index for February 2012

| Feb 6, 2012
PL/SQL is on the 17th place TIOBE Index (February 2012).
It's was 32nd in February last year (February 2011)!
In 2008 and 2007 in February it was in 13th position in the index.

SQL Navigator 6.6 released

| Dec 15, 2011
Quest Software released the 6.6 version of SQL Navigator. Mainly it corrects some bugs.
The most usefull new feature is in the history search (where you can search the runned scripts/commands for an expression) to filter the commands by type.

Check the Release Notes and the Known Issues List.

TIOBE Programming Community Index for December 2011

| Dec 15, 2011
PL/SQL is on the 14th place TIOBE Index (december 2011).
It's was 23st in November last year.
It was in 13th in 2008 and 2007 in the same month!

Oracle Magazine November-December 2011 online versions

| Dec 7, 2011
Oracle Magazine November-December 2011:
Flash version
HTML version

File list from the server

I've been asked by one of my architects whether there is a quick way of see a list of file existing in the random folder on the server. The first response was - NO, because all file system communication should go via DIRECTORY object (starting 10g).

But I recalled that (more...)

TIOBE Programming Community Index for November 2011

| Nov 19, 2011
PL/SQL jumped to the 12nd placeTIOBE Index (november 2011).
It's was 20st in November last year.

Logger Project Moved Temporarilly

| Nov 9, 2011
The site was decommissioned recently. I was hosting a number of projects there including “Logger”, my PL/SQL instrumentation package. Until I find a new home, here’s a temporary link to the latest release (1.4) or if you just want to view the readme use this link. I’ll update this post when I decide on [...]

Oracle Database 11g Release 2 Express Edition Available

| Sep 5, 2011
Oracle Database 11g Release 2 Express Edition (Oracle Database XE) final version is available. It's "an entry-level, small-footprint database based on the Oracle Database 11g Release 2 code base. It's free to develop, deploy, and distribute; fast to download; and simple to administer." DownloadDocumentation Do not forget to check the Open Bugs and Known Issues section.

Oracle Magazine September – October 2011

| Sep 5, 2011
HTML version
Flash version

TIOBE Programming Community Index for August 2011

| Aug 30, 2011
PL/SQL is again in the 22nd place TIOBE Index (August 2011).
It's was in 21st last month.


| Aug 3, 2011
NTLM, or more properly NTLMSSP is a protocol used on Microsoft Windows system as part of the so-called Integrated Windows Authentication.

Integrated Windows Authentication is also known as HTTP Negotiate authentication, NT Authentication, NTLM Authentication, Domain authentication, Windows Integrated Authentication, Windows NT Challenge/Response authentication, or simply Windows Authentication.

In Microsoft Internet Information Server (IIS), the system administrator can protect a website or folder with "Integrated Windows Authentication". When you browse to this website or folder, you must enter your Windows (domain) username and password to get access (although Internet Explorer will, depending on your security settings, send your credentials (more...)

New version of Alexandria Utility Library for PL/SQL

| Aug 3, 2011
I've just uploaded a new version of the Alexandria Utility Library for PL/SQL.

Updates include both small bug fixes and some major new features (which I'll return to in another post).

Among the improvements are:

  • Additional functions in OOXML_UTIL_PKG for working with Excel 2007 and Powerpoint 2007 files.
  • Kris Scorup has contributed improved CSV parsing to the CSV_UTIL_PKG. It now handles double quotes and separator characters inside strings.
  • Anton Scheffer's packages for building PDF and XLSX files have been included in the library.
  • The PL_FPDF library by Pierre-Gilles Levallois is a port of the FPDF library for PHP. Pierre-Gilles Levallois (more...)

Mythbusters: Stored Procedures Edition

| Jul 29, 2011

These days, the use of database stored procedures is regarded by many as a bad practice.

Those that dislike stored procedures tend to regard them as incompatible with the three-tier architecture:

By breaking up an application into tiers, developers only have to modify or add a specific layer, rather than have to rewrite the entire application over. There should be a presentation tier, a business or data access tier, and a data tier.

This is illustrated as follows:

Note that the "tiers" in the figure should actually be labelled "layers", for as the accompanying Wikipedia article says:
The concepts (more...)


| Jul 19, 2011
Quest Software site has recently make available a new section in its website called QuestTV with several videos about its services and products. Some of these videos are also available in Quest Software Channel in YouTube.

Most interesting videos for PL/SQL developers:

Using Toad for Oracle with Oracle Instant Client (this series is helpful even for people that do not use TOAD but want to install and configure Oracle Instant Client.
  • Using SQL Tracker available with TOAD or SQL Navigator
Steven Feuerstein (renowned PL/SQL (more...)

TIOBE Programming Community Index for July 2011

| Jul 17, 2011
PL/SQL is again in the 21st place TIOBE Index (July 2011).
It's was in 22nd last month.

Interactive SVG example on iPad (iPhone) via Oracle PL/SQL Server Pages

A couple of weeks ago we talked about Flash on Android via Oracle APEX. Today let’s check the competitor’s offer. Unfortunately Apple products don’t support Flash. The good news however is that they do support SVG, as do most web browsers (IE7/8 is pluginable and IE9 is going to support it properly). I first came [...]

Calling a database procedure with table input and output parameters from Java

In my previous blog post I explained how to call a database procedure using only a few lines of Java code. I already hinted that it is possible to use custom types and tables, etc. Let's see an example of that in more detail.

Database artifacts

Suppose we have the (more...)

Calling an Oracle database procedure from Java with only ONE line of code

About a year ago I was working on an ADF application for one of our clients. One of the problems they faced was that they needed to call a lot of database procedures. It is not very hard to call a database procedure if you are familiar with the JDBC (more...)

Oracle Application Express 3.2 – The Essentials and More is Published!

I mentioned a while ago that this book was nearing completion but I have just been advised that it has now been published.

You can get the full description and buy a copy here…

Oracle Application Express 3.2 – The Essentials and More

Well done Matthew and Arie!