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
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
![]() |
![]() |