[This article was migrated to the author’s GitHub Pages site here in July 2025]
I recently had some discussions on PL/SQL coding standards centred around some documents I’d come across on the internet, as well as some internal company standards documents.
Here are a couple of extensive company standards documents that have been made public:
And this is another interesting document, by William Robertson, which emphasizes common sense in application of standards:
These are all valuable documents, but it was thought that many developers would not read and remain familiar with long documents of this kind, and a 2-page summary standards might be useful. Here is my attempt, as a Word document on Scribd:
Brendan’s 2-Page Oracle Programming Standards by Brendan Furey
Hi Brendan,
being a fan of standards I think that such a short list of recommendations is a very good idea – thank you! Recently I have seen that there is a CodeChecker extension for sql developer that inspects the compliance to the Trivadis standards: http://www.salvis.com/blog/2014/04/30/trivadis-plsql-sql-codechecker-for-sql-developer-released/ – and tool support is also a great help, I think.
Regards
Martin