Thursday, April 23, 2009

BI, RDBMS x 3,


BI

Now this is how to post a truly technical blog entry. One sentence of English at the start, one at the end, the rest is code: Bursting: Conditional delivery at the BI Publisher developer blog. A few less words and the blog would be entirely machine readable.

RDBMS

Ok, this next one, unlike the BI posting above,  this posting over at the Database Geek Blog has a whole paragraph up front before it goes into code: Use a Pipelined Function to Select Source Code Arguments.

also in the realm of PL/SQL and more generally in the realm of logic is Eddie Awad's posting (with links to Tom Kyte) on Why WHEN OTHERS THEN RAISE Can Be Harmful.

And finally a nice article on Miladin Modrakovic's Blog: Oraclue on Detecting Deadlock Source (Part 1).  Once again, almost all code, and very useful code at that. You can use his example to set up a deadlock and then try a variety of tools to see how well they do on tracking it down.



2 comments:

APC said...

Your URL for the Eddie Awad article is actually a duplicate of the previous Database Geek link.

Cheers, APC

Christopher Gait, Oracle Infogram Editor said...

I'm glad that someone is paying attention. Possibly not me. Thanks! I fixed it.

Official, Youbetcha Legalese

This blog is provided for information purposes only and the contents hereof are subject to change without notice. This blog contains links to articles, sites, blogs, that are created by entities other than Oracle. These links may contain advice, information, and opinion that is incorrect or untested. This blog, links, and other materials contained or referenced in this blog are not warranted to be error-free, nor are they subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this blog, links and other materials contained or referenced in this blog, and no contractual obligations are formed either directly or indirectly by this blog, link or other materials. This blog may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission. The opinions and recommendations contained in this blog(including links) do not represent the position of Oracle Corporation.

Oracle, JD Edwards, PeopleSoft, and Siebel are registered trademarks of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.