11G OCM Downloads

October 4, 2009 by Douglas

The software download list is below.

Read the rest of this entry »

11G OCM Upgrade Exam Details Released

October 4, 2009 by Douglas

The announcement for the OCM 11G Upgrade exam is here.

Read the rest of this entry »

Handling Three-Value Logic

May 28, 2009 by Douglas

I have just finished reading Applied Mathematics for Database Professionals By Lex de Haan and Toon Koppelaars. I was struck by the discussion about nulls in Appendix D, especially about the inconsistent handling of NULLs between constraints and predicates in SQL (see p.344)

Read the rest of this entry »

Oracle Database 11g OCM Exams Available Soon!

May 5, 2009 by Douglas

SQL and Relational Theory: How to Write Accurate SQL Code

April 25, 2009 by Douglas

I have just finished reading SQL and Relational Theory: How to Write Accurate SQL Code by C.J.Date. Here are some of my thoughts on the book.

Read the rest of this entry »

How To Nail An Interview (22 Tips)

April 17, 2009 by Douglas

Resumes and Job Interviews

April 14, 2009 by Douglas

I have been reading through the slush pile of resumes to find job interviewees
Read the rest of this entry »

Multi-Row DML

March 27, 2009 by Douglas

A developer at work wanted a way to multi-row updates based on a set of values. The underlying model is a two-level tree. For example, a manager with one or more employees. Instead of having a series of transactions (insertions or deletions), a new list of employees is presented for the manager.

Read the rest of this entry »

NORDIC Schema for TopLink Demonstration (4)

March 1, 2009 by Douglas

Having discovered the limitations of JDeveloper for support of object-oriented database objects in NORDIC Schema for TopLink Demonstration (3), we will clean up the NORDIC schema in both the offline and online databases, before exploring TopLink itself.

Read the rest of this entry »

NORDIC Schema for TopLink Demonstration (3)

March 1, 2009 by Douglas

Now to complete the creation of the ANIMAL type started in NORDIC Schema for TopLink Demonstration (2) by using JDeveloper and TopLink.

Read the rest of this entry »