You can use an Oracle sequence to generate your unique value. The
sequence can be created with various options so that the next value of
the sequence obtained meets your needs. You should be able to reference
the CREATE SEQUENCE syntax in the SQL Manual and then use the pseudo
column nextval in your insert statement/trigger to post the new value.
There also is a pseudo-column called currval which contains the latest
value of the sequence that your session has obtained. Hope this helps.
Received on Tue Sep 23 1997 - 00:00:00 CDT
