That's three times as fast as the second example. However, the dynamic SQL is still at a disadvantage. The execute immediate still does its parse, ... Even in Oracle 10g, ...