Oracle naming convention [closed]

Closed. This question is opinion-based. It is not currently 开发者_如何学JAVAaccepting answers.

---

Want to improve this question? Update the question so it can be answered with facts and citations by editing this post.

Closed 6 years ago.

Improve this question

Can some one give me an oracle naming convention. I surf the web. but could not find a good site. I tried to find one from oracle site. but failed. Thanks in advance.

---

see the link.Oracle9i documentation

Some other links for naming conventions

http://www.gplivna.eu/papers/naming_conventions.htm

http://www.dba-oracle.com/standards_schema_object_names.htm

http://ss64.com/ora/syntax-naming.html

---

you are looking for something like table naming?

http://ss64.com/ora/syntax-naming.html

---

Looking for the same, I found this Oracle's naming convention for DB objects... which imo doesn't really help : https://docs.oracle.com/cd/E18727_01/doc.121/e12897/T302934T458266.htm#4164876

Google will give you many other other. Here are a few examples :

http://www.toadworld.com/platforms/oracle/w/wiki/4844.variables-best-practices-naming-conventions#establish-clear-variable-naming-conventions

https://oracle-base.com/articles/misc/naming-conventions

http://ss64.com/ora/syntax-naming.html

Personally, the most important thing from my pov is to have a correct case consistency.
Either you spell all your SQL KEYWORDS IN CAPITALS and your business_vocabulary with lower_case, or the opposite, but avoid mixing both : it just makes everything less readable.

Then, of course, it's good to adopt some conventions, but I guess they are often subjective choices, and the relevancy of such choices depends on the database's purpose. Good conventions won't be really necessary for a 10 tables DB :)

Among the examples of conventions I personally use, I prefix views with v_, prefix all my PK names with id_, and my FK with fk_... also, my PK is always my first column (I now avoid multiple columns PK), and all my FK are placed after it (no FK at end of table).

Keep in mind that these examples are my personal choices