Michael McLaughlin's Page

Looking forward to meeting old and new friends at OOW11. If you want to stop by, I'm in the bookstore at Moscone North on Monday and Wednesday at 9 a.m. for a book signing.

I was doing some testing tonight, and discovered something curious on Oracle 11.1.0.7.0. Basically, if you add a CLOB column through an alter statement, drop the table, recreate the table, and try to alter the table again to add the CLOB column it's still there. It is like the table was never dropped, but DBMS_METADATA.GET_DDL and the DBA_LOB and DBA_SEGMENT views don't find it before you try to re-add the column. When you re-create it, you get an ORA-01430. After the error is thrown,… Continue

This is just a thought about making our information more accessible. I've adopted a print.css on my main blog to expand all content on an entry and strip unnecessary header, footer, and sidebar information.



Aside from the striping the useless page stuff, a print.css let me unfold all my entries. This was important since I adopted JQuery folding on the pages based on feedback from readers. The folding forces me to reflect a bit more before I post something and hopefully avoids… Continue

When I presented the concept at the Utah Oracle User’s Group (UTOUG) Training Days 3/12-3/13/2009 it became clear the community could benefit from more detail about table and pipelined table functions. I updated my old entry, more or less rewrote it entirely, now there's a 16 page post. Hope you enjoy it.



Also, about a month or so ago I began tweeting. You can find me at MacLochlainn… Continue

I've moved to my own domain for reasons set out in the last blog post on the old site and first directly on the new site. If you've got an iPhone give it a hit and then reflect on using the iPhone plugin on your own blog. I've migrated all the content to the new site and eventually things should forward but I wanted to give you a heads up if you've set an RSS feed to the old site. The new site is… Continue