ODTUG 2006 Conference Handouts/Presentations available

Lucas Jellema

Last night, the ODTUG 2006 Conference Committee announced that all handouts and presentations from this year’s (well, in fact that is last week’s) conference are available for download from the ODTUG website at http://www.odtug.com. Until August 1st, all material can be downloaded by the general public. After that date, you […]

The minimum number of statements required for Inserting Records from Two Source Tables into Four Target Tables – Introducing Multi Table Insert

Lucas Jellema 2

It's Showtime! Today at ODTUG 2006, Alex and I are presenting our Oracle Quiz on SQL and PL/SQL – the water is still burning. We will present our audience with 15 questions on SQL and PL/SQL features and functions. Even though most questions are on core database features, many of […]

Cost Based Optimizing through time travel? – the value of meta-data for enabling Query Rewrite

Lucas Jellema 5

Query Rewrite is an increasingly more important feature of the Oracle database. Linked intimately to Materialized Views, Query Rewrite is used by the CBO to make queries leverage intermediate results – often aggregate values or pre-joined records – available in Materialized Views when executing a query, thus preventing the need […]

Database Systems 2006 – Conference on Service Oriented Architectures

Lucas Jellema

Today I attended – and presented at – the Database Systems 2006 conference – an annual Dutch conference on Database Architecture and Technology, Enterprise Integration and Service Oriented Architectures as well as Information Architecture and Business Intelligence. The main theme – at least in the sessions I attended – was […]

Summary results for all dates, including the ones that I do not have data for – example of using Partition Outer Join – Oracle10g SQL Feature

Lucas Jellema

Trying to make myself useful by answering some of the questions on the OTN SQL and PL/SQL Forum, I came across this question: Group Above Report problem…not able to display absent rows in date range. The question could be translated to: I am trying to aggregate records by date and […]