When invoking a PL/SQL procedure or function, you can specify the value of its parameters using either positional, named, or mixed notation. Let’s review what each notation means and then demonstrate the best way to add new parameters to an existing subprogram without breaking existing code.

Consider this simple package as an example:

CREATE OR REPLACE PACKAGE […]

Links to interesting, educational, informational, or just plain fun websites…

Do you think there is a point in arranging an Obfuscated SQL Contest, modeled after the infamous Obfuscated C Contest? Chen Shapira asked. I replied: Great idea! So, welcome to the first ever Oracle Community contest.

To learn more, or to participate, proceed to this page on OracleCommunity.net.

In the SQL Developer group on OracleCommunity.net, both Chris and Chen complained about the new SQL Developer’s automatic code completion and how it could freeze the entire editor while waiting for the popup to appear.

I have experienced this behavior too. It is really frustrating when it happens. The solution, however, is really simple. In SQL […]

Tab Overload And Deluge

source

Pop quiz: How many tabs are there in a Toad?

The Business Technology blog of the Wall Street Journal hates the kind of gibberish in this Oracle press release about Oracle Communications IP Service and Network Management that simplify Lifecycle Management of complex IP-Based services.

The release is a string of bewildering tech terms and vague verbiage… Technology that businesses use is marginalized enough […]

After the huge success of their first video, Mogens and Morten demonstrate an Oracle database installation, again wearing a straitjacket:

(via Kevin)

As mentioned on OracleCommunity.net, Oracle SQL Developer 1.5 Early Adopter 1 (EA1) is now available for download. As with any new release, there are new features and bug fixes. But, they are not yet detailed in the release notes.

However, I know that the one feature that I have been eagerly waiting for is finally here, […]