The software download list is below.
11G OCM Downloads
October 4, 2009 by Douglas11G OCM Upgrade Exam Details Released
October 4, 2009 by DouglasThe announcement for the OCM 11G Upgrade exam is here.
Handling Three-Value Logic
May 28, 2009 by DouglasI 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)
Oracle Database 11g OCM Exams Available Soon!
May 5, 2009 by DouglasSQL and Relational Theory: How to Write Accurate SQL Code
April 25, 2009 by DouglasI 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.
How To Nail An Interview (22 Tips)
April 17, 2009 by DouglasSeth Godin pointed out how to How To Nail An Interview (22 Tips).
Read the rest of this entry »
Resumes and Job Interviews
April 14, 2009 by DouglasI 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 DouglasA 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.
NORDIC Schema for TopLink Demonstration (4)
March 1, 2009 by DouglasHaving 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.