oracle standards documentation

[Brian_274]

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.

[Sanjay Kumar Suri]

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

[Yogeeraj_1]

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

[Yogeeraj_1]

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