Need Help!

From: Amy <qdsun2001_at_yahoo.com>
Date: 26 Jun 2002 06:19:56 -0700
Message-ID: <c95702b.0206260519.147bfd54_at_posting.google.com>

Hi Everybody,
[Quoted]   I need help in writing a PL/SQL program.

  There are two sets of number : 200 - 300, 450 - 650. I want to insert each number to each row of a table that has 300 rows. Let's say, the 1st row get 200, the 2nd row get 201, the 3rd row get 202 etc.

  Do you think I can create two sequences so that once one sequence is used up I can drop the first sequence and start use the second sequence? Is there any procedure or function that makes a sequence adaptable if the number series changes?

Thank you for your help

Amy Received on Wed Jun 26 2002 - 15:19:56 CEST