Automatic Update of Fields with Oracle 6

  We are creating a new database which contains the two following fields (among others), these are the desired functions we want from these fields.

"update_date" -- everytime the user does a commit the system should
enter the current date in this field.

"id" -- we want the system to generate this unique id field in
sequential order (1,2,3....). Each time a new record is created it picks the next number in the order.

        I'm thinking we can use the Oracle max() function and the SysDate function. My question is... Is there a way to "attach" these functions to a field  (using SQL*Plus or something) so that the fields in the Database will be automaticaly updated when we do a commit on a record? (I was hoping Oracle triggers would do this, but we only have Oracle 6).

        We're trying to avoid using Oracle forms for this project.  Can anyone please help?

Please respond to "malachi_at_cs.iastate.edu"

Thank you in advance,
Malachi Wurpts Received on Tue Apr 02 1996 - 00:00:00 CEST