About

Foreword

In the I.T. world of today, robust and secure applications are becoming more and more important. Many business processes no longer work without I.T. and the dependence of businesses on their I.T. has grown tremendously, meaning we need robust and maintainable applications. An important requirement is to have standards and guidelines, which make it possible to maintain source code created by a number of people quickly and easily. This forms the basis of well functioning off- or on-shoring strategy, as it allows quality assurance to be carried out efficiently at the source.

Good standards and guidelines are based on the wealth of experience and knowledge gained from past (and future?) problems, such as those, which can arise in a cloud environment, for example.


Urban Lankes
President of the bord of directors
Trivadis


The Oracle Database Developer community is made stronger by resources freely shared by experts around the world, such as the Trivadis Coding Guidelines. If you have not yet adopted standards for writing SQL and PL/SQL in your applications, this is a great place to start.



Steven Feuerstein
Team Lead, Oracle Developer Advocates
Oracle


Coding Guidelines are a crucial part of software development. It is a matter of fact, that code is more often read than written – therefore we should take efforts to ease the work of the reader, which is not necessarily the author.

I am convinced that this standard may be a good starting point for your own guidelines.


Roger Troller
Senior Consultant
finnova AG Bankware


License

The Trivadis PL/SQL & SQL Coding Guidelines are licensed under the Apache License, Version 2.0. You may obtain a copy of the License athttp://www.apache.org/licenses/LICENSE-2.0.

Trademarks

All terms that are known trademarks or service marks have been capitalized. 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 are periodically made to this document without notice. The authors reserve the right to revise this document at any time without notice.

Revision History

VersionWhoDateComment
0.1Troller17.03.2009Created.
0.1Troller17.03.2009Created.
0.2Kulessa04.05.2009Extended.
0.3Reiner12.05.2009Extended with comments in code.
0.4Troller14.05.2009Extended formatting.
0.5Kulessa20.05.2009Added more CodeXpert rules.
0.6Troller22.05.2009Formatting changes. Added categories to rules.
0.7Reiner10.06.2009Extended with example code commenting.
0.8Troller18.06.2009Finalized.
0.9Bushnell23.06.2009Translation.
1.0Troller01.07.2009Ready for inspection.
1.1Troller19.08.2009Added Inspection results AFl.
1.2Troller21.08.2009Added Inspection results ThM.
1.3TrollerApril 2010Several Corrections. New Rule Oracle Supplied Packages.
1.3.1TrollerOctober 2010Some formatting.
2.0TrollerAugust 2011Added Error Handling Section. Added rule 23, 30, 31, 43.
3.0TrollerJanuary 2016Added Rules for ORACLE 12c. Added SQALE Metrics. New guideline numbering system.
3.1TrollerApril 2016Corrections
3.2SalvisbergJanuary 2017Various small corrections
3.3Salvisberg07.07.2018Migrated from Microsoft Word document toMkDocs, added missing reasons, prefixed rules with "G-" as in PL/SQL Cop.
3.4Salvisberg20.09.2019SeeRelase Information