auto increment of number

[rk68]

I'm newbee in Oracle 9i forms. I have a created a form which has a tracking number (primary key). When a user adds a record, the tracking number should automatically increment OR when the record is saved.
1) How can this be done ?
2) What if more than 1 user adding records, how will the tracking no. gets updated ?
3) Can I display the tracking no. at time of entry ?

Thanks
Raj

 

[lewisp]

If you dont need the numbers to be guaranteed consecutive, then use a sequence.

 

[rk68]

Can I do without sequence, if yes, how ?
The number is a redemption tracking no. & it has to be a genuine number.

 

[dbomrrsm]

CREATE SEQUENCE YourNumberSequence 
    INCREMENT BY 1 
    START WITH 1 
    MAXVALUE 99999999 (or NOMAXVALUE) 
    MINVALUE 1 (or NOMINVALUE) 
    CYCLE (or NOCYCLE - the default) 
    CACHE n (or NOCACHE) 
    ORDER (or NOORDER)

to use

INSERT INTO YourTable 
    ( RowID, OrderDate, SalesPerson ) 
    VALUES ( YourNumberSequence.NEXTVAL, SYSDATE, 'DugsDMan' );

[blue]DBomrrsm[/blue]

 

[rk68]

Sorry to ask this silly question but can't help.
Where do I create the 'sequence' in the form & where do I
put the 'Insert' SQL ?
Since I'm using the default Oracle tool bar & menu do I need to have the save button ?

Thanks
Raj