Re: CONSECUTIVE Values

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Tue, 18 Nov 2003 22:44:55 -0500
Message-ID: <hnplrvgtajpkdh5dln8n8vp7039ovt5rbp@4ax.com>

On Tue, 18 Nov 2003 15:30:36 -0500, "Robert C" <rchin_at_panix.com> wrote:

>There may be gaps in this column value...
>How can I ensure to return a result of CONSECUTIVE values...like:

I've written about this problem. Have a look at the following two articles:

http://otn.oracle.com/oramag/oracle/02-sep/o52sql.html

http://four.pairlist.net/pipermail/oracle-article/2003/000006.html

The first article should help. The second talks about a new 10g feature that bears on this problem.

Jonathan Gennick --- Brighten the corner where you are http://Gennick.com

Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to Oracle-article-request_at_gennick.com and include the word "subscribe" in either the subject or body. Received on Tue Nov 18 2003 - 21:44:55 CST