Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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 <shortcutter_at_googlemail.com>
Date: Fri, 21 Dec 2007 20:50:21 +0100
Message-ID: <5t2jntF1bmulaU1@mid.individual.net>


On 21.12.2007 14:31, EdStevens wrote:

> On Dec 21, 3:34 am, Jeroen van den Broek
> <nlt..._at_baasbovenbaas.demon.nl> wrote:

>> 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
> 
> 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

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US