Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Naming Convention for Oracle DB objects

659873Sep 18 2008 — edited Sep 19 2008
Is there any naming convention for DB objects that you would recommend? Under Oracle, all object names are uppercase. That changes a little bit my habits of using CamelCase. I would like to learn good practices from experienced Oracle users.

For example adding prefixes like T_ for table (T_Contact), P_ for procedure, F_ for functions etc. Are there any pros and cons?

Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 17 2008
Added on Sep 18 2008
#general-database-discussions
11 comments
2,890 views