In terms of standards I have found Feuerstein's "Oracle PL/SQL Best Practices" a great reference for PL/SQL coding standards. With regard to Oracle installation standards Cary's original OFA white paper or even a installation guide such as this are useful references: http://www.dbspecialists.com/presentations/oracle920linux.html Although file system and Oracle database enhancements like Automatic Storage Management (Oracle 10G) convolute the relevance of these timeless standards it is still darn useful to standardize the file system/mount points...nothing like every file system being unique as a snow flake or what I like to call "the APS standard" when one is faced with an Oracle "data warehouse" outage at 6pm. I have used elements of "Extreme Programming" to develop overall programming/development standards with regard to unit testing, change management, versioning, etc. for small teams. Finally, I have always tried to include, even under threats, protests, and angry accusations of witchcraft and sorcery, some sort of enterprise database monitoring such as OEM (Oracle Enterprise Manager) including alerts and automation of routine maintenance (almost been lynched for it if that walker brigade would have caught up to me) as part of the Oracle standards, assuming you are developing standards that are this far reaching. Keep in mind, there are several good PL/SQL best practices presentations on the Internet that offer a somewhat condensed version of the main points in Feuerstein's book. Thanks. Ellis PS I would send the standards I developed in the past but fear they might incite the same level of Luddite reprisal I experienced and I would hate to see your data center over-turned and beaten with hammers and the feet of gold-plated walkers. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of TOMPKINS, MARGARET Sent: Wednesday, August 04, 2004 7:46 PM To: oracle-l@xxxxxxxxxxxxx Subject: RE: standards I personally prefer firing before flogging, but flogging first does set = a better example..... Respectfully, > Maggie Tompkins - CAD SQA > Corporate Applications Division > Technology Services Organization - Kansas City > Defense Finance and Accounting Service > 816-926-1117 (DSN 465); Margaret.Tompkins@xxxxxxxx -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of david wendelken Sent: Wednesday, August 04, 2004 6:37 PM To: oracle-l@xxxxxxxxxxxxx Subject: Re: standards How about: PL/SQL Programmers who use exception blocks like this will be flogged, = then fired from their job. EXCEPTION WHEN OTHERS THEN NULL; END; :) -----Original Message----- From: David <thump@xxxxxxxxxxxxxxxx> Sent: Aug 4, 2004 3:45 PM To: oracle-l@xxxxxxxxxxxxx Subject: standards I ahve been asked to write the standards for the company in terms of Oracle databases. I have never done anythign like that before... Anyone have any pointers or skeletons or examples I could review? Cheers --=20 .. David ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------