Re: Why Oracle does not allow rollback of DDL statements?
Date: Thu, 13 Nov 2008 05:12:09 -0800
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.orgReceived on Thu Nov 13 2008 - 07:12:09 CST