The importance of Oracle
Standards
We see here a section that discusses standard names for schema
objects, including standard table names, standard index names, and
standard constraint names:
http://www.dba-oracle.com/standards_schema_object_names.htm
Oracle DBA's must pay careful attention to the structure and
naming conventions and standards within the database. All
applications will reside within the same schema owner and naming
conventions will be used to identify table/index components:
This tip sheet offers-up some great advice on creating a set of
“standards” for Oracle system development.
http://www.dba-oracle.com/online_systems_standards.htm
This has some good advice for creatring application development
standards for Oracle:
Application coding standards will ensure uniformity within the
application.
-
Affirmative error checking - All process logic
will check all non-zero Oracle return codes.
-
Standard help key - Complete Help documentation
will be implemented with the standard F1 Help key and all online
help screens will have context sensitive (mouse-over)
descriptions.
-
Fast validation - All HTML screens will use
Java for instant field entry validation, before going to the
database.
-
Standard screen template - A standard template
will be used for all screens, utilizing "re-usable included
components, as follows:
|
