Re: ORACLE-SQL : Sequence Problem (Need SQL GURUS)

azhan98_at_tm.net.my wrote:

> Please advice me on this problem......
>
> I create a sequence say s_mysequence
> The sequnce will increment its value by 1.
> From my understanding, sequnce will alway increase its value when called.
> (Or can we reset the value?).
>
> Here's the problem:
> How can I write the code (SQL or PL/SQL or SQL*PLUS)that will increase the
> sequence value until it match the value of other parameter value and reset
> its value back to 1.
>
> I have to do this since I want my sequnce to be dynamic.
> [snip]

Have a look at the statement ALTER SEQUENCE Received on Thu Sep 10 1998 - 04:22:10 CDT