Re: Oracle Application Standards

stroup_at_grove.ops.lmsc.lockheed.com () writes:
>We've been designing Oracle applications for several years now (under VMS)
>using some informal standards. Now we're about to start up a standards team
>to address issues such as:
> Source Code Management (Forms, SQL scripts, Menus, etc.)
> Naming conventions
> Visual standards for Forms
> Etc, etc, etc....
>I'd appreciate any information on how you control your production
>applications.
> Thanks in advance

Naming standards -- I try to name objects in a consistent fashion. For example, a unique three character prefix for each application in front of each table name. Indexes are named for the object and columns upon which they are based. Constraints are named based on the column/table and function (pk, fk, unique, check, etc). ALL object names are constrained to 18 characters where absolutely possible and to 27 otherwise because of the prefix. NO public synonyms for security reasons, but always named for the table upon which they are based.
ZZ

-- 
Andrew Finkenstadt       | Vista-Chrome, Inc.   |     NIC Handle: AF136
GEnie Unix Sysop/Manager | The Printing House   |    ...!uunet!rde!andy 
+1 904 222 2639 home     | 1600 Capital Cir SW  |   andy_at_GEnie.geis.com
+1 904 575 0189 work     | Tallahassee FL 32310 |  andy_at_vistachrome.com
 <> Send mail to ora-request_at_vistachrome.com to join Unix, CASE, and
 <> Desktop Oracle discussions.