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.
On the underscores/capitalisation business; Oracle is generally not
case-sensitive, so really you have to use underscores if you want
readability.
Regards
David Lord
-----Original Message-----
Sent: 13 July 2001 20:21
To: Multiple recipients of list ORACLE-L
Our old office used to do that as well, and I thought it was redundant.
You can always look up the type in dba_objects to know what the type is. It
might be worth more to keep those extra characters as part of the name.
-----Original Message-----
Sent: Friday, July 13, 2001 1:21 PM
To: Multiple recipients of list ORACLE-L
Hi ,
We use
T_ for tables
P_ procs
V_ view
TR_ trigger
F_ function
S_F_ synonym of function
----- Original Message -----
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Friday, July 13, 2001 6:40 PM
> Were looking to develop naming standards within our organization and I am
> wondering what others use. Is there a formal process similiar to ofa? Do
> shops typically use underscores or case? (policy_number / PolicyNumber)
What
> about abbreviating? Enforcement processes ? Other considerations?
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Tracy Rahmlow
> 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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bunyamin K. Karadeniz
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Lange
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Lord, David - C&S
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).
