Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

oracle standards documentation

Brian_274
Frequent Advisor

oracle standards documentation

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.
3 REPLIES
Sanjay Kumar Suri
Honored Contributor

Re: oracle standards documentation

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

A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.
Yogeeraj_1
Honored Contributor

Re: oracle standards documentation

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Yogeeraj_1
Honored Contributor

Re: oracle standards documentation

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)