Archive for February, 2008

Two Quick and Simple Tips That Will Help You Write Better PL/SQL

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 […]

5 Useful Links for 2008-02-25

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

Oracle Community Contest: Obfuscated SQL Code

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.

Control When Oracle SQL Developer Completes Your Code

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 […]

Now We Know What TOAD Means

Tab Overload And Deluge

source

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

Do You Understand This Oracle Press Release? WSJ Does Not

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 […]

Oracle Nose Job - Part 2

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

(via Kevin)

Better SQL Formatter in Oracle SQL Developer, Finally a Reality

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, […]