Skip to content





Daily Archives Tuesday, May 2008

Synchronizing mappings and process flows using OMB Plus

I was recently in a situation where I had to delete a package (transformation) in OWB and then re-import it from the database, because I had deleted it and re-imported it, every mapping and process flow that referenced the package lost its reference to it. I could have gone through each mapping and process flow [...]

Posted 20 May 2008 † Jon Mead § Uncategorized ‡ Comments Off °

Bugs in the Matrix

My wife introduced a theory to me years ago. She observed that certain odd themes tend to repeat themselves in high frequency over the course of about a week, then disappear back into obscurity.
Her theory was that if you apply numerology to these coincidences, you could translate chance into good fortune, e.g. using the coincidences [...]

Posted 20 May 2008 † Jake § Uncategorized ‡ Comments Off °

The Lazy Developer’s Way to Populate a Surrogate Key

Consider this table:

CREATE TABLE t
(
id NUMBER PRIMARY KEY,
name VARCHAR2(100)
);

You want the column id to be populated from this sequence:

CREATE SEQUENCE t_s;

Here are a couple of ways you can do this:

1- Use the sequence’s next value directly in the insert [...]

Posted 20 May 2008 † Eddie Awad § Uncategorized ‡ Comments Off °

PADI Rescue Diver, check

This past weekend, I was diving again at Haigh Quarry in the 50-57 degree (F) water to complete the dives for the PADI Rescue Diver certification. The dives were great and I continue to learn a lot from some good teachers and buddies too. I completed the dives and demonstrated the skills successfully, so I’m [...]

Posted 20 May 2008 † Dan § Uncategorized ‡ Comments Off °

What a Difference a Year Makes

This year is not last year.
Last year, I spent hours talking Web 2.0 to teams in development. Collectively, we probably held 20 or so educational sessions and then a similar number of follow up roundtables to discuss ideas spawned by the first session.
This year, I’ve been spending days collecting requirements of teams that want to [...]

Posted 20 May 2008 † Jake § Uncategorized ‡ Comments Off °