RE: Naming Standards - Thoughts Needed

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 <ORACLE-L_at_fatcity.com> 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: Tracy.Rahmlow_at_aexp.com
>
> 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: ListGuru_at_fatcity.com (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: bunyamink_at_havelsan.com.tr

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: ListGuru_at_fatcity.com (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: kgel_at_ppoone.com

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: ListGuru_at_fatcity.com (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: David.Lord_at_hayscsg.com

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: ListGuru_at_fatcity.com (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).