use of triggers

Hi everybody,

i'm testing oracle7 for my diploma thesis and want to ask for your opinion about triggers.
my first thougth was, to let a trigger compute the key field when inserting new data. but triggers are not allowed to insert in the same row as the insert-statement that started the trigger. problems also occur when a trigger updates a foreign key that references a table/row on which the trigger-starting-statement is working.
does anybody use the triggers? what for?

btw: s.o. spoke about books on client/server. can he tell me again?

bye,
dirk

--


                    | Voice:    (089) 319 42 73    


Dirk Slootz         | Internet: slootz_at_informatik.tu-muenchen.de 


                    | Fido:     2:2480/120.5