> IMHO the reason for prefixes/postfixes is so that dependent objects can be
> given a more 'natural' name, that relates it to the object it depends on.
> Therefore T_ is redundant because tables don't depend on anything, but V_,
> T_ etc _may_ not be. Similarly, in pl/sql, you often want a procedure
> parameter to be the value of a column on a table. You can't use the name of
> the column because that would cause problems in the sql statements that use
> the value, so the usual standard is to prefix all parameters with p_ and
> local variables with l_ or v_.
>
> BTW, TR_ is not generally sufficient - you may want to have more than one
> trigger on a table. I would use something like TAI_ = Trigger After Insert,
> TBIUD_ = Trigger Before Insert, Update or Delete, etc.
>
I fully subscribe to this. For triggers, it's even worse than this if you want
to be exhaustive, because you may wish to indicate not only whether the trigger
is a before or after trigger (or instead of ...), but also it it is fired once
per statement or for each row. Currently (my own standards evolve over time) I
tend to forget about AFTER or BEFORE, but postfix my triggers with _IUD_RTRG or
_IUD_STRG, where I/U/D specifies whether it is fired by insert, update or
delete and RTRG stands for row trigger and STRG for statement trigger.
Also, opinions may be different about this, but I prefer postfixing over
prefixing. The reason is that when you query USER_OBJECTS and order by
OBJECT_NAME you will find related objects (tables, indexes, triggers ...)
grouped together. Prefixing would put the emphasis on the type, which can make
sense as well, but since you already have USER_ or DBA_ views for each type I
find it less necessary and I think that postfixing 'adds value' in a way.
Regards,
Stephane Faroult
Oriole
Corporation
---------------------------------------------
Performance tools for Oracle �
http://www.oriole.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroult
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
