Oracle Open World 2010 presentation: Forms2Future: the ongoing journey into the future for Oracle based organizations

Lucas Jellema

Many organizations around the world have adopted Oracle technology for developing custom applications. Over the past two decades, they may have used PL/SQL, Reports, Forms, Designer, Portal or the Web PL/SQL Toolkit. Many of these organizations have come to face new challenges: more agility or functionality, new user groups or […]

Oracle RDBMS 11gR2 – new style hierarchical querying using Recursive Subquery Factoring

Lucas Jellema 1

  Oracle Database 11g Release 2 introduces the successor to the good old Connect By based hierarchical querying, called Recursive Subquery Factoring. The basics are described in a previous article: This article will show some additional examples of using this recursive subquery factoring syntax. The essence of this recursiveness: […]

The "X" Product – An X(ML) Database Opportunity?

Marco Gralike 2

“Exadata – Extreme Performance Warehousing“, that’s how the presentation on the last Friday morning from Oracle Open World started (Orig. Presentation Title was “Oracle’s New Database Accelerator: Query Processing Revolutionized”) while speaking about the new database machine. And indeed it was a revolution and it took the blogosphere by night. […]

Extreme performance introduced by patchset smart scan

Gerwin Hendriksen

Larry yesterday did his keynote here at Oracle Open World introducing the “Oracle(R) Exadata Storage Server”. This morning I attended a session about the technical details behind the server. In principal the server works with 8 nodes running RAC on Oracle Enterprise Linux 5. For the storage management ASM is […]

OOW 2007: (most) presentations available for download

Lucas Jellema

Most of the presentations for the sessions presented at Oracle Open World 2007, last week in San Francisco, can be downloaded from the Content Catalog  at: You will need to use the username/password combination cboracle/oraclec6 to download presentations. At are all the keynotes, of which the one by […]

My first steps with Oracle BI Publisher Enterprise Edition create a report based on the OraBlogs rss-feed

Lucas Jellema 4

After receiving a new, pretty powerful laptop, on Thursday and installing the Oracle BI Enterprise Edition on Friday, this weekend sees my first steps with the BI Publisher (previously known as XML Publisher).  My colleague Marcos is our (AMIS’s) real expert in this area – you may have seen some […]

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 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 […]