Question on sequence number with Dual Table

From: John Yang <zyang_at_waveline.com>
Date: 20 Nov 2002 04:34:55 -0800
Message-ID: <c137b465.0211200434.5a1c2b9e@posting.google.com>

I am a beginner here, so I would really appreciate if you could give me some pointers to the following problem.

I am using the Dual table to generate increasing sequence numbers, 1,2,3.... But the output numbers seems to jump from time to time, i.e. 1,2,3,11,12...

First of all, I don't know if this is the best way of generating incremental sequence numbers. Second, I could not understand why the sequence number jumps, since there is only one instance calling the Dual table, why should it not be sequential? Or is it supposed to be sequential?
I am running on Linux.

Many thanks in advance.

John Received on Wed Nov 20 2002 - 06:34:55 CST