topic Re: oracle standards documentation in Operating System - HP-UX

oracle standards documentation

Brian_274 — Wed, 17 Mar 2004 13:56:08 GMT

Hello All,

Does any know where I can find a document that explains what the naming conventions for tables, procs, triggers, etc.. An example is I usually name a view ending with '_v' or '_vw'. I'm trying to create a naming document for my current company and I'd like to use a standard one that everyone else uses.

thanks.

Re: oracle standards documentation

Sanjay Kumar Suri — Thu, 18 Mar 2004 02:05:42 GMT

Have a look at this link:

http://data-dist.jrc.it/en/software/Guideline.html

We used to have 3 characters in the begining of the object name signifying the object type such as tbl, viw for table, view etc.

sks

Re: oracle standards documentation

Yogeeraj_1 — Thu, 18 Mar 2004 23:31:09 GMT

hi,

http://examples.oreilly.com/orbestprac/
points to a zip file containing some
suggested naming conventions (related to Steve Feuerstein's book).

hope this helps!

regards
Yogeeraj

Re: oracle standards documentation

Yogeeraj_1 — Thu, 18 Mar 2004 23:40:05 GMT

hi again,

The only naming conventions we have are in PLSQL.

local variables must start with L_
parameters must start with P_
global package variables must start with G_

That is so a Parameter ENAME won't get confused with a column named ENAME in a
query -- we never would have a column p_ename -- so there is no ambiguity.

Beyond that (and beyond disliking prefixing column names with their table names) we haven't any.

regards
Yogeeraj