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.
With all your permissions may I provide the link to this page on my technical blog.
By all means put a link .:)
yonderboi said...application is sometimes miswritten as APPLICATON or
Thanks for the heads-up. I think I've corrected the typos.
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.
Thanks for the heads-up. I've corrected the typos. Glad it helped. :)
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).
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. :)
Sebastian said...Perfect, now all clear.
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.