Naming conventions por pl sql

pl /sQl & sQl
coDinG GuiDelines

PL/SQL & SQL
Coding Guidelines
Trivadis AG

Document Version ©2009 Trivadis AG

1.0

 

Foreword
  Coding Guidelines are an important quality standard for any programming language. Not only that coding based on standards results in better software products, standards also help programmers to work in teams. These coding guidelines represent manyyears of experience – not only delightful ones - in constructing and maintaining PL/SQL and SQL programs. These programs are pieces of software to implement business logic in order to support high end data processing. Or in other words to get value out of one of the most important assets of a company - the company's information. From small functions to help to automate a database administrators workto complex frameworks for historization or other purposes. Many software products are programmed fully in PL/SQL or in SQL. I am convinced that these PL/SQL and SQL Coding Guidelines are a valuable contribution to enhance software quality and improve team performance. May the code be with you.

             Urban Lankes CEO Trivadis     "Roger and his team have done an excellent job of providinga comprehensive set of clear standards that will undoubtedly improve the quality of your code. If you do not yet have standards in place, you should give strong consideration to using these as a starting point."       Steven Feuerstein Pl/SQL Evangelist            

PL/SQL Coding Guidelines

2

 

License
Trademarks
All terms that are known trademarks or service marks have beencapitalized. All trademarks are the property of their respective owners.

Disclaimer
The authors and publisher shall have neither liability nor responsibility to any person or entity with respect to the loss or damages arising from the information contained in this work. This work may include inaccuracies or typographical errors and solely represent the opinions of the authors. Changes areperiodically made to this document without notice. The authors reserve the right to revise this document at any time without notice.

Revision History
Version 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 1.0 1.1 1.2 Who Troller Kulessa Reiner Troller Kulessa Troller Reiner Troller Bushnell Troller Troller Troller Date 17.03.2009 04.05.2009 12.05.2009 14.05.2009 20.05.2009 22.05.2009 10.06.2009 18.06.200923.06.2009 01.07.2009 19.08.2009 21.08.2009 Comment Created. Extended. Extended with comments in code. Extended formatting. Added more CodeXpert rules. Formatting changes. Added categories to rules. Extended with example code commenting. Finalized. Translation Ready for inspection Added Inspection results AFl Added Inspection results ThM

PL/SQL Coding Guidelines

3

 

Table of Contents
Inhalt1. Introduction .......................................................................................................................6 1.1. 1.2. Scope..........................................................................................................................6 Document Conventions ..............................................................................................6Coloring & Emphasis:...........................................................................................6 Keywords.............................................................................................................6 Icons.................................................................................................................... 6

1.2.1 1.2.2 1.2.3 2. 3.

Why are standardsimportant ..............................................................................................7 Naming Conventions.......................................................................................................... 7 3.1. 3.2. 3.3. 3.4. General Guidelines .....................................................................................................7 Naming Conventions for...