Re: problem about Sequence

Sorry, should be USER_SEQUENCES...

Jay!!!

Jason Jay Weiland wrote:

> Ken,
>
> Try using CURRVAL to find maximum number
> generated from your sequence. You can also get
> additional details from the USER_SEQUENCE table.
>
> SQL> insert into registration
> values (user_id_seq.NextVal, 'Ken Ho');
> 1 row created.
>
> SQL> insert into registration
> values (user_id_seq.NextVal, 'Jay Weiland');
> 1 row created.
>
> SQL> select * from registration;
>
> USER_ID USER_NAME
> --------- -----------
> 1 Ken Ho
> 2 Jay Weiland
>
> SQL> select user_id_seq.CurrVal from dual;
>
> CURRVAL
> ---------
> 2
>
> SQL> select *
> 2 from user_sequences
> 3 where sequence_name = 'USER_ID_SEQ';
>
> SEQUENCE_NAME MIN_VALUE MAX_VALUE INCREMENT_BY C O
> CACHE_SIZE LAST_NUMBER
> ------------------------------ --------- --------- ------------ - -
> ---------- -----------
> USER_ID_SEQ 1 1.000E+27 1 N N
> 20 21
>
> Jay!!!
>
> Ken Ho Kwok Fai wrote:
>
> > I made a sequence in a table "test" by the following SQL:
> >
> > ============================================================
> > create table registration
> > (user_id number NOT NULL primary key,
> > user_name varchar2(11)
> > );
> >
> > create sequence user_id_seq start with 1 increment by 1 nocycle;
> > =============================================================
> >
> > After I insert some values to the table, how could I know the
> > max sequence number? Is there a table to store the sequence? I don't want
> > to select it from the table and the compare the largest number as it
> > needs a lot of time. Any method that could allow me to get the max
> > sequence number? Thanks a lot.
> >
> > --
> > Regards,
> > Ken Ho
Received on Wed Oct 28 1998 - 10:28:02 CST