Skip to content

Daily Archives Thursday, August 2008

Apex 3.1.2 Released

Hot off the press, Application Express version 3.1.2 has just been released.
The link to the direct download is here, if you’re upgrading via the patchset on Metalink then the patch number is 7313609.
You can find more details about the patch here.
There looks like quite a few fixed bugs (it’s always hard to say that without [...]

Posted 28 August 2008 † John Scott § Uncategorized ‡ Comments Off °

SQL Function Spotlight: TRIM

The SQL function TRIM has been around since Oracle 8i and maybe earlier. TRIM enables you to trim characters from a character string. The following examples demonstrate its usage and show you a few little known features of this simple function.

Remove leading and trailing blank spaces:

SQL> SELECT TRIM (’ mystring ‘) FROM dual;

TRIM(’MY
——–
mystring

Remove [...]

Posted 28 August 2008 † Eddie Awad § Uncategorized ‡ Comments Off °

The Mystery of OBIEE Bridge Tables

If you’ve played around with the Oracle BI Administrator tool for a while, you may have noticed a box you can tick in the Logical Table Properties dialog, called “Bridge Table”. If you’re familiar with Ralph Kimball and some of this dimensional modeling ideas, you’ve probably heard of this concept before, but it’s not all [...]

Posted 28 August 2008 † Mark Rittman § Uncategorized ‡ Comments Off °

oracle-validated RPMs now available outside of ULN

For those of you who’d like to use the oracle-validated RPM, but don’t have access to ULN, here they are: For Enterprise Linux 4 For Enterprise Linux 5…

Posted 28 August 2008 † sergio.leunissen § Uncategorized ‡ Comments Off °

Christian Antognini

I noticed Christian’s blog a few weeks ago and forgot to mention it, but it’s been added to my blog-roll now. His book turned up yesterday and, despite the fact it’s in a long queue of books to read, I’m looking forward to it. A very quick initial glance was quite seductive (if it doesn’t seem too weird to say that about an Oracle book!).

Posted 28 August 2008 † Doug Burns § Uncategorized ‡ Comments Off °

The Art of Estimation

If you’ve worked in product management or consulting for any amount of time, you’re familiar with the estimation gremlin.
I’ve always hated managing projects. For me, it’s too much whip-cracking and tattletaling, but it’s an unfortunate chore that I’ve been unable to avoid. If you worked on a project I managed, I’m really sorry. I was [...]

Posted 28 August 2008 † Jake § Uncategorized ‡ Comments Off °

Bitmap index examples

Between assignments (mostly, OBIEE and BI Applications work) and a family holiday in the Austrian Alps I have been helping Mark with some of the examples he will be demonstrating as part of his 11g Data Warehousing Seminar. I must confess that I, too, will be using the examples in some of my data warehouse [...]

Posted 28 August 2008 † Peter Scott § Uncategorized ‡ Comments Off °

Geeking out with Ubiquity

Big news today was the very-early (0.1!) release of Mozilla Labs’ Ubiquity.
What is it? That’s a really good question. It took me several passes to fix on the awesomesauce that is Ubiquity. I scanned the Techmeme coverage, thinking it was some translation tool, then speed read Scoble’s post on it. Sounded more interesting, but still [...]

Posted 28 August 2008 † Jake § Uncategorized ‡ Comments Off °