Oracle Database Discussions

Hi everyone,

I wanted to ask you about Oracle Naming Conventions. I've found a lot of stuff on the internet. Here's a short summary of what I've discovered so far...

These are absolute:
1- All names should be between 1 & 30 characters (database names accept 8 characters max)
2- Names can not be duplicated in the same namespace
indexes, constraints... are in one "schema" namespace
tables views... are in another "schema" namespace
3- Only letters (lower & upper), numbers and $, # & _ are accepted in a name.
4- Quoted identifier are case sensitive and accept all kind of characters.

The previous rules can not be violated otherwhise the object won't be created.


Now they are a lot of naming conventions...

- Always use a plural names for table (USERS i.o. USER)
- use a prefix or suffix in constraint, indexes, ...
USERS_PK, USER_IDX...


I want to talk about these. What are your own naming conventions?

Thanks