Catalogue of SQL and PL/SQL bad practices: Call for participation

I started compiling a list of Oracle SQL and PL/SQL bad practices, with the intention of producing a comprehensive catalogue of common and recurring programming mistakes, that can be used as a check-list for code reviews or given to junior developers. I have identified about 30 bad practices so far. For each bad practice, I provided a list of symptoms in the code, an explanation why it causes problems and a list of preferred solutions.

My goal with this list is primarily to start a discussion about similar recurring issues that other people have noticed. That discussion should lead to a more complete list which the community will then be able to use, hopefully, to learn something from the mistakes of others and to produce better code.

I would really appreciate your feedback - if you are interested in discussing these practices we can either do it in this usenet group, or start a separate mailing list.

You can download the first version of the catalogue in PDF form from http://gojko.net/effective-oracle

--
gojko adzic
http://gojko.net