Re: Query to return PK sequence gap ??

On Oct 12, 12:03 pm, "Vladimir M. Zakharychev" <vladimir.zakharyc..._at_gmail.com> wrote:

[snip]

>
> So it seems to be a not completely reliable way to generate monotonic
> sequences when used standalone, but it appears to be working
> identically in all versions since 9.2 when used in subqueries.
>

I don't know much about this, but I'm wondering if the _old_connect_by_enabled will make a difference (and whether PL/SQL Developer uses it). Man, all those connect by bugs are scary.

Bug 6487891 looks to be Brian's demo.

jg

--
@home.com is bogus.
Everything in the world is on craigslist.
http://www.signonsandiego.com/uniontrib/20071012/news_1b12tech.html