What I do have is experience of working as an Oracle Developer and DBA since 1993. This experience has mainly revolved around fixing stuff that was broke when I got there rather than designing shiny new applications ( though I’ve done one or two) whilst following all of the given Best Practices – whatever they were at the time.

Like many people working with Oracle, I’ve frequently been grateful to find helpful information on the finer points of Oracle and PL/SQL from luminaries such as Kyte and Feuerstein. I’ve also frequently been frustrated when these experts are invoked to justify some design decision or coding standard that is completely inappropriate for the situation I find myself in ( i.e. trying to fix or enhance a running production system that’s been designed in such a way as to make what’s being proposed impractical).

These guys are experts in Oracle. But, as with anything, there are myriad ways to write bad code in PL/SQL and fixing this isn’t straight forward.

I make no claim to have anything like the in-depth knowledge they have of this subject.

So, this is more of an explanation of how and when to apply their pearls of wisdom to the mess you ‘re currently confronted with rather than the ideal situation which these ideas are often, necessarily, predicated on.

Both Kyte and Feuerstein do often make the point that you should never take the pontifications of an expert as gospel and should always test them out and adapt them to the circumstances in which you find yourself. Often however, this message gets forgotten in the headlong rush to “just get it done”.

As to the second of your questions, it would probably be more accurate to call this blog “The sub-Kyte”….but then this would rob me of the pleasure of standing in front of a mirror pretending to be Johnny Rotten and miming to Anarchy in the UK. “I am a sub-Kyte” just doesn’t scan.

Hello Mike,
Thanks a lot for pointing me to your blog … a nice one that for sure I will enjoy reading :):)
I kind of understand your point, though, while being forced many times to act in real life
against those “gospels”, I like to find myself in a “pure world” where everything is ideal,
at least for saying to myself: “Yes, I know how things should be done correctly, even if many times I cannot effectively do so”.

Best Regards,
Iudith Mentzel
Oracle developer since 1988, but, unfortunately, never a DBA up to this day.