8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Naming Conventions


Craig D said...

We use a Progress to Oracle dataserver which maps Oracle schemas for use in Progress databases.
Suffixing sequences with _SEQ as a naming convention in Oracle causes problems when the sequence is viewed via the Progress dataserver.
we have to use _SQ as a convention to avoid this issue.

Kamlesh said...

Hi,

With all your permissions may I provide the link to this page on my technical blog.

Thanks

Tim... said...

Hi.

By all means put a link .:)

Cheers

Tim...

yonderboi said...

application is sometimes miswritten as APPLICATON or
APPLCIATIONS

Tim... said...

Hi.

Thanks for the heads-up. I think I've corrected the typos.

Cheers

Tim...

Mor said...

Hi,
There are a few typos (it happens):
serveral -> several
dependant -> dependent
the the -> the

Thanks for the good post, I copied some of the ideas to a development guideline I'm writing and you get full credit in it.

Tim... said...

Hi.

Thanks for the heads-up. I've corrected the typos. Glad it helped. :)

Cheers

Tim...

Sebastian said...

Inconsistency in naming of foreign keys.
Description says: "The foreign key column on the dependent table may be named using the full table name or the alias, along with the column name."
Example says:"APPLICATION_FUNCTIONS.APPLICATION_ID -> APPLICATIONS.ID"
The full table name is "APPLICATIONS" (plural) however example says "APPLICATION_ID" (singular).

Tim... said...

Hi.

It's not actually inconsistent, since the FK only points to a singular application, therefore it shouldn't be plural. The wording is bad so I've changed it. :)

Cheers

Tim...

Sebastian said...

Perfect, now all clear.
Thx

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.