Re: Why Oracle does not allow rollback of DDL statements?

Mladen Gogala wrote:

> It also has the ability to skip the first N records
> in the fetch and start fetching from an offset in the cursor. That ability
> is worth its weight in gold when it comes to producing web pages. Oracle
> still cannot do that.

I'm not so sure about this though it might take a very bit of a kludge. Consider this syntax:

FORALL <index_name> IN INDICES OF <collection> [BETWEEN <lower_boundary> AND <upper_boundary>] <sql_statement>;

With a global temporary table you should be able to accomplish the goal.

And yes it would not be quite as elegant.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org