Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Query to return PK sequence gap ??

Re: Query to return PK sequence gap ??

From: Brian Tkatch <N/A>
Date: Mon, 15 Oct 2007 10:16:29 -0400
Message-ID: <jht6h31g9boaooe09rdents8293paab5bv@4ax.com>


On Fri, 12 Oct 2007 15:07:49 -0700, joel garry <joel-garry_at_home.com> wrote:

>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

Thanx for ther report.

B. Received on Mon Oct 15 2007 - 09:16:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US