Re: incrementing function in Oracle

does this mean that the operation is done only on the primary key of the table?

thanks

"Markus Stuhlpfarrer" <mstuhlpfarrer_at_hollomey.com> wrote in message news:3B41C9E0.1A2A1619_at_hollomey.com...
> make a sequence:
>
> CREATE SEQUENCE testseq
> INCREMENT BY 1
> START WITH 1
> MINVALUE 1
> MAXVALUE 100000000
> NOCYCLE
>
> EVERY time you call the value of the sequence it is raised by one,
> so be careful with selecting it
>
>
> Kah-Tat Lim wrote:
>
> > dear all,
> >
> > need your help on this,
> >
> > the problem that I am facing is
> >
> > 1) i have 3 tables (for e.g) i) Card Table ii) Room Table iii) Meeting
 Table
> > 2) what should i do when everytime when a record is to be created in
 each of
> > these tables, i would want to increment a certain field in the tables by
 1,
> > for e.g
> > when a record is to be inserted into Card Table
> > the Card ID field is to be incremented by 1, that means if the
 present
> > record in Card Table have the Card ID of 8901, once an insertion of a
 record
> > is to be done in Card Table, the Card ID will have to be 8902.
> >
> > as i have to prior experience in this before, can anyone help? thanks
>
Received on Tue Jul 03 2001 - 08:41:33 CDT