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 05:31:23 -0800 (PST)
Message-ID: <6f45734e-1bdb-4059-a372-0c843fb9e02c@a35g2000prf.googlegroups.com>


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. Received on Fri Dec 21 2007 - 07:31:23 CST

Original text of this message

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