Lex de Haan
Lex de Haan (1954 - 1 February 2006) was a Dutch professional who specialized in Oracle and relational database technology.
Lex de Haan worked for Oracle Corporation from 1990 to 2004. He was a senior curriculum manager for the education division for four years.
Since 1999, de Haan has been a member of the Dutch national body of the ANSI/ISO standardization committee for the SQL Language, working on the SQL:1999 and SQL:2003 standards. De Haan was also a founding member of the Oaktable network.
He founded his company, Natural Join B.V. on 1 March 2004. Natural Join was originally a one-man consultancy that specialized in educational activities about the Oracle Database, but it later organized a range of seminars and events.
Lex died on 1 February 2006 at 16:00 hours CET after a long battling with cancer. This was made possible as Dutch law allows adult patients suffering from incurable diseases to request assisted suicide. This event was described as his final "shutdown abort".
Lex's widow, Juliette Nuijten, became the director and owner of Natural Join. She organized some seminars with the aid of the Oaktable Network in honour of her late husband.
Every Oracle database with the HR schema installed still shows Lex as employee number 102:
SQL> SELECT * FROM employees WHERE employee_id = 102;
EMPLOYEE_ID FIRST_NAME LAST_NAME
----------- -------------------- -------------------------
EMAIL PHONE_NUMBER HIRE_DATE JOB_ID SALARY
------------------------- -------------------- --------- ---------- ----------
COMMISSION_PCT MANAGER_ID DEPARTMENT_ID
-------------- ---------- -------------
102 Lex De Haan
LDEHAAN 515.123.4569 13-JAN-93 AD_VP 17000
100 90
Books
- Mastering Oracle SQL and SQL*Plus by Lex de Haan (Paperback - Dec 30, 2004) - ISBN 1-59059-448-7
- Applied Mathematics for Database Professionals (Expert's Voice) by Lex de Haan and Toon Koppelaars
- Leerboek Oracle SQL 3e geheel herziene uitgave (Dutch)
- Leerboek Oracle SQL, ISBN 90-395-2286-3
External links
- Lex's Wikipedia Page
- Lex in Memoriam
- Retrieval: Multiple Tables and Aggregation (one of his last articles)
