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: EdStevens <quetico_man_at_yahoo.com>
Date: Fri, 21 Dec 2007 12:49:13 -0800 (PST)
Message-ID: <f7ad202a-0a34-499b-a330-36e87c65ac16@e10g2000prf.googlegroups.com>


On Dec 21, 1:50 pm, Robert Klemme <shortcut..._at_googlemail.com> wrote:
> 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

The sales pitch. Received on Fri Dec 21 2007 - 14:49:13 CST

Original text of this message

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