Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: Catalogue of SQL and PL/SQL bad practices: Call for participation

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

From: Robert Klemme <>
Date: Fri, 21 Dec 2007 20:50:21 +0100
Message-ID: <>

On 21.12.2007 14:31, EdStevens wrote:

> On Dec 21, 3:34 am, Jeroen van den Broek
> <> wrote:

>> On Dec 20, 9:13 am, Gojko Adzic <> 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 from
>> 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:
>> HTH.
>> --
>> Jeroen
> I attended that.  Thought it was pretty light-weight.  Just a lead-in
> to pushing their consulting services.

It seems this is the default operation mode for webcasts. I haven't seen one that was truly inspirational and at some point stopped attending them. Did I miss anything?

        robert Received on Fri Dec 21 2007 - 13:50:21 CST

Original text of this message