Archive for June, 2008

Always Bulk Collect 0

Posted June 23, 2008
You learn something new every day, right? Well, I certainly do (more or less). Even about PL/SQL, about which I am sure many people think I already know everything. Far from it.
In fact, I learned just last week from the PL/SQL Product Manager, Bryn Llewellyn, that his recommendation regarding cursor FOR loops and bulk collect is different from mine – and for a very good reason.

More Blogs 0

Posted June 10, 2008

It’s good to see some more people joining in, particularly those I already know and admire.

First up is Mark Bobak, who I’ve met at several conferences and, as you can tell from his first few posts, is likely to have some interesting technical tales to tell.

How to Run an OS Command from PL/SQL 0

Posted June 4, 2008

Oracle doesn’t make it terribly easy to run operating system commands from within a PL/SQL block. I suppose that’s understandable, given that PL/SQL is an embedded database-oriented language. Still, developers do ask me on a regular basis about how they can do this.