Dec 20 2007
Effective Oracle Programming: SQL and PL/SQL bad practices
Download version 1.0 of Oracle SQL and PL/SQL Bad Practices (2007-12-20)
This is a catalogue of bad practices in Oracle SQL and PL/SQL development. The aim of this document is to serve as a check-list for anti-patterns and to raise awareness about some common errors in Oracle database development.
Oracle PL/SQL is a powerful and feature-rich programming environment. As with any such complex programming environment, there are pitfalls that should be avoided, but recognising them and knowing how to solve the problem often requires years of experience and burning your fingers a few times. Due to data-driven nature and highly concurrent execution environment of Oracle databases, the side effects of such bad practices may not appear for a long time, but when they do the consequences are dire, often leading to data corruption and long nights spent in panic-mode support.
This document contains the patterns of bad PL/SQL code that I have repeatedly found in various applications and databases.
Hopefully, it will help other people learn from my mistakes and the mistakes of developers whose code I have reviewed.
Please provide feedback and help make this list more complete. You can do that by sending information on similar bad practices you have noticed or commenting on issues I have outlined in this document. I would especially like to hear from you if you have a better solution for any of the issues or if you do not agree with any of the explanations or potential problems.
[...] Adzic составил очень любопытный документ Oracle SQL and PL/SQL Bad Practices. А я [...]
Good Work !!!
Definitely a very useful guide to use the best approach for programming..
Nice document. Just a sugestion: label your bad-pratices soo people could mention then easily…for instance BAD-001, etc..
[...] document below contains patterns of bad SQL and PL/SQL code that Gojko Adzic has repeatedly found in various applications and databases. Some of the bad practices [...]