trigger question

[jinkata]

if there are two triggers on a table, how do you know which one will execute first - considering their triggering events are the same?

[dmitriy]

Hi,

I am not sure, but for a given event Oracle can look at object_id of each trigger for this event and fire them in asc or desc order of their object_ids.
I have a doubt that Oracle can fire them randomly.
Though, I've never read about it in Oracle Doc. If anyone could give the link, it would be nice.

Regards,

[jinkata]

hey,

thanks for the reply dmitriy. you might be right. the other possibility i was thinking of was alphabetically, but that seems to far fetched.

i'll try asking metalink and see what they have to say.

thanks again...