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

On Dec 20, 9:13 am, Gojko Adzic <goj..._at_gmail.com> wrote:
> 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 fromhttp://gojko.net/effective-oracle
>

Last week a 45-minute webcast/webinar was published from EnterpriseDB: "Database Worst Practices: The Top 5 Mistakes Developers Make and How to Avoid Them".
You can download the 25 MB ZIP-file containing the webcast at: http://www.enterprisedb.com/news_events/webinars/webinarkey1010.do

HTH.

--
Jeroen