In his latest post titled Less is More, More or Less, John Russell, the man behind tahiti.oracle.com, reveals a very interesting fact about the space needed to store PL/SQL variables of varchar2 datatype. He writes:

If you don’t know exactly how much space is needed for a PL/SQL variable, the most space-efficient thing you can do […]

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

Alexander Kornbrust of Red-Database-Security has started a new Oracle security blog (just added to OraNa.info). He also posted new Oracle security videos, 10 as of today.

OraNA.info, the unofficial Oracle news and blogs aggregator, has a new look and cool new features:

OraNA now runs on Wordpress, which means that, unlike the older version, OraNA is no more limited to showing only the latest 20 posts. It is still a River of News style aggregator, but the river has become as long […]

This is one of uncle Larry’s homes. He owns 12 properties in Malibu alone, with a total value of $180 million. This one is only $20 million. It has a cable railway that acts as a shuttle between the mansion and the pool. Impressive!

Source: Haute Living. Via: Valleywag.

According to this SDA Asia Magazine article:

OTN has reportedly bumped pass the four hundred thousand member point making it the largest developer community for Oracle in the Asia Pacific region and second largest worldwide… OTN’s new position in the India market also translates to an increase in Oracle’s total online community in the […]

I stumbled upon Paul Gallagher’s blog from the OTN TechBlog. Paul created a Perl script that scrapes the HTML of an Oracle forum user profile web page and generates an RSS feed from that user’s most recent posts.

When I saw “HTML scraping” I immediately thought of Dapper. I have used Dapper before to generate a […]

Recently, Technorati introduced the Technorati Authority. It is the number of blogs (not links) linking to a website in the last six months. The higher the number, the more Technorati Authority the blog has.

In addition to Authority, there is also the Technorati Rank. It is calculated based on how far you are from the top. […]

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

I almost forgot that the Oracle Joins series is not complete yet. So here is the last episode, a quick and easy anti-join and semi-join refresher.

Anti-joins: Anti-joins are written using the NOT EXISTS or NOT IN constructs. An anti-join between two tables returns rows from the first table for which there are no corresponding rows in […]