OUG Harmony 2011

Just going home from OUG Harmony seminar. I took the room of a cancelled session and gave a presentation that I put together after Thursday dinner. I tittled the presentation "What is bugging me". So satisfied with other presentations I attended. Eg now I know indexing possibilities in MySQL.

In my presentation I got to show an email from my report on oracle documentation. The issue Tom Kyte mentioned in his keynote speak. There is a feedback possibility in every page in online documentation pages. It is working as Tom mentioned.

Also mentioned beta testing possibility. Currently 11.2 XE available.

One issue was dealing with ora_rowscn. I noticed that my oracle support pages does have only one workaround to a Bug 9360157: WRONG RESULTS WHEN USING ORA_ROWSCN PSEUDOCOLUMN USING ANSI JOIN


The buggy way:

select dep.n,dep.ora_rowscn  
  from testnorowdep nodep  
 inner join testrowdep dep on dep.n=nodep.n
  where dep.ora_rowscn > :scn ; 

The mentioned workaround SQL 92 join way - do not use ansi join.

select dep.n,dep.ora_rowscn  
  from testnorowdep nodep  , testrowdep dep  
 where dep.n=nodep.n 
   and dep.ora_rowscn > :scn;

An additional workaround - use ora_scn in join condition

  select dep.n,dep.ora_rowscn 
   from testnorowdep nodep  
 inner join testrowdep dep 
    on dep.n=nodep.n 
    and dep.ora_rowscn > :scn;