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

From: DA Morgan <>
Date: Thu, 13 Nov 2008 05:12:09 -0800
Message-ID: <>

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 (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Thu Nov 13 2008 - 07:12:09 CST

Original text of this message