23 April 2007

Oracle PL/SQL Best Practices and Common Mistakes

Eddie Awad dug up some videos from Quest Software of PL/SQL-god and Borat-hater Steve Feuerstein talking about the best and worst of PL/SQL programming.

The videos offer some tasty advice, including tips on writing cleaner, more modular code, and use of BULK COLLECT and FORALL to improve mass data processing performance, and use of table functions. It's even worth sitting through the Quest infomercial towards the end of each video.

1 comment:

  1. That is true. Although from all the stories of lawsuits that I hear (e.g. the college boys in the RV), the Borat people get the releases signed before the filming begins.

    ReplyDelete