Oracle autonumber question

[TheEarthWillShake]

How do you generate a autonumber that needs to be put in more than one table to create a relationship?

For example I have 3 tables.

TBgenData
Proj_Num*
Proj_Name

TBdate
Date_ID*
Proj_Num
Date

TBfinancial
Fin_ID*
Date_ID
YTD_Budg

In this case, the Date_ID needs to be generated, and then put into the TBfinancial table and another table called TBschedule.

Thanks

EDIT* I believe sequences can be used but I don't understand how that all works out.

 

[Drakkon]

you have to create sequences for each ID that you want to generate numbers for. On each "insert" you have to use sequenceid.NEXTVAL to generate the new/next ID. Then use sequenceid.CURRVAL to insert into the subsequent tables

http://psoug.org/reference/sequences.html

 

[drebo]

Right. In Oracle, the only way to make a field autonumber is to create a sequence and a trigger and on insert, the trigger will assign the field the next value in the sequence.

Fun, right?

 

[TheEarthWillShake]

Not fun at all lol.