die Seilerwerks

Chronicling Life, Love, Linux and Oracle database administration.

Posts Tagged ‘feuerstein

More Log Buffer Pity

without comments

The latest Log Buffer is out, and this blog gets a mention for doing little other than posting about an older Feuerstein article. Honestly, I’ll gladly accept any non-negative mention of this site, so keep ‘em coming!

Written by Don Seiler

April 27, 2007 at 10:44 am

Posted in Uncategorized

Tagged with ,

Feuerstein on Error Tracing

without comments

I’m still catching up on some readme bookmarks, and find myself once again face-to-face with PL/SQL sensei Steven Feuerstein. This man has some of the best headshots I’ve ever seen.

This time Steven is dropping some science regarding the DBMS_UTILITY.FORMAT_ERROR_BACKTRACE function, new in Oracle 10g, for better exception handling in PL/SQL.

Written by Don Seiler

April 25, 2007 at 9:12 pm

Posted in Uncategorized

Tagged with ,

Oracle PL/SQL Best Practices and Common Mistakes

with 4 comments

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.

Written by Don Seiler

April 23, 2007 at 1:59 pm

Posted in Uncategorized

Tagged with , , ,