Re: How do you name your triggers?

In article <1996Jan9.222808.23136_at_rosevax.rosemount.com>, mark rostron <markro2_at_frmail.rosemount.com> writes:
> For any given table, there are 12 possible triggers:
>
> - 3-choice for insert,delete,update
> - 2 choice for before/after
> - 2 choice for row/statement
>
>
> We name our triggers:
>
> <table_name>_<aft/bef>_<ins/del/upd>_<row>
>
> statement triggers use null for last suffix.
>
> mr
>

This doesn't work if you have multiple triggers of the same type on the same table!

I prefer to use a descriptive name for my triggers. (e.g. "update_total_balance_trg")

-- 
------------------------------------------------------------------------------
Pierre Hollard                                 
Oracle Database Administrator                  Phone: (404) 827-0656
Turner Broadcasting System, Inc.              E-Mail: phollard_at_dev1.turner.com
------------------------------------------------------------------------------