Maclochlainn's Weblog

Michael McLaughlin's Old Technical Blog

Archive for the ‘Generic’ Category

Update on blog

leave a comment »

As qualified 8 months ago, I moved the blog here. If you’ve comments on the posts here, please feel free to move them there.


Written by maclochlainn

June 30, 2009 at 8:27 pm

Posted in Generic

Migrating to a new blog site …

with one comment

A number of friends wanted me to do things that weren’t possible while keeping my blog on’s web site. Things like code formatting, downloads for software, et cetera …

You can find the new blog at:

So, I’ve migrated it to my own domain. I’m in the process of configuring the rest of the domain. I’ll update you through the blog as I complete the process.

I’ve got grand plans (lets hope there’s time). For example, I’m planning to migrate and update the domain too. I’ll plan tutorials on Java, PL/SQL, and PHP initially as well as administration tips, techniques and walk through steps for my favorite platforms. As time allows, I’ve got some stuff comparing SQL across platforms – much beyond the trivial Oracle’s SPOOL is MySQL’s tee (not herbal tea).

While my perspective may change over time, I’m quite fond of Mac OS X, Ubuntu, and Red Hat. I won’t exclude Microsoft because we must live with it, but isn’t CrossOver sweet! I’d actually tried to get Oracle to run through it. I may yet, I’m still playing with it.

I’m trilled that Chris Jones and Justin Kestelyn got me blogg’n. I’ve always wanted to contribute more but the forums have mavens with much more time than I have to answer questions. The blog lets me share ideas and concepts as they travel with me on a daily basis.

Stats on the blog pages may not migrate but if time allows maybe I’ll write a plugin if I can’t find one. Generally, I don’t think anybody cares about the stats. It’s the information to solve problems, and I hope that’s what you find useful in my blog.

By the way, it wasn’t just the ability to have my blog pages look cool on my iPhone that drove the change, but it does look nice!!!

Written by maclochlainn

November 1, 2008 at 10:08 pm

Posted in Generic, Mac, Oracle, Ubuntu

Reflecting on six months of blogg’n

leave a comment »

It is nice to know that the entries I’ve made have readers. It’s surprising to see almost 22,000 direct hits and another 5,000 syndicated hits in the 6 months of blogg’n. The following table contains the list and links of the top blogs that have netted 5 or more hits per day.

Blog Entry Posted Hits Avg
How to configure Mac OS X as an Oracle Client 9/2/2008 1,402 36
How to convert XML to CSV and upload into Oracle 6/22/2008 1,019 9
Creating an external table that uses SQL*Loader 6/19/2008 945 8
Creating an external table that uses Oracle Data Pump 6/19/2008 899 8
Pipelined functions and PL/SQL Tables 5/11/2008 859 5
Reading an external directory from SQL or PL/SQL 6/05/2008 667 5

I plan to move this to my own site shortly and will provide notice and pay WordPress to forward. Naturally, any comments are welcome.

Written by maclochlainn

October 17, 2008 at 11:05 pm

Posted in Generic

Oracle OpenWorld 2008 – Day 1

with 2 comments

I just finished my book signing. Alas, no body showed up. Rumor has it books sales are down yet again this year. I guess that’s because folks search the web.

I think one of the mystery photographers caught me sitting at the table while I was waiting for the throngs of folks to buy my latest PL/SQL book (obviously in some dream state). Since I’ve heard Oracle Database 11g adoption rates are low, at least from a few vendors here at OpenWorld, perhaps I can blame that.

Things are much the same as they were last year, the year before, et cetera. However, the real business of the conference occurs in the Game Room of Moscone West. As you can see the budget dollars of organizations are well spent here.

Hopefully, there aren’t too many managers who visit my blog. These pictures probably shouldn’t be seen by management. Especially, if they’re the ones approving the expense reports, eh? I hope that nobody gets busted from these photos. :-)

After the soda and snack here in the OTN lounge, I’m Off to a 5:30 p.m. session. Then, I’m heading over to the OTN Night at the Hilton in San Francisco. It starts at 7:30 p.m. this evening. We’ll only stay about 30 minutes or so to visit and then off to check in at the hotel.

Also, thought some of those taking classes at night or in college would be interested to know about the iPhone Developer University Program. It’s new and slick. We’ve actually got a course up and running this term at BYU – Idaho. A couple students are already working for a company developing iPhone applications remotely. I think that they’re calling it insourcing to Idaho.

A Google search that showed up in my statistics wanted to know how to check for external table file sources. I’ve got a sample that should be posted later this evening. If there are things you’re interested in that I’ve not explored, let me know. I always like new ideas but time typically goes to the projects at hand.

The reason for the Mac OS X configuration material is because I’ve been building a server to run multiple instances of the Oracle Applications 11i eBusiness Suite for the book I’m currently working on. Along with that, I’ve been documenting configurations for OPAL (Oracle, PHP/Perl/Python, Apache, Linux) stacks on various platforms. I’ll post my own version of Ubuntu later this week or on the weekend. Unfortunately, I’ve got some real work developing activity diagrams, and they’ll compel my attention this week between sessions and at the hotel.

Written by maclochlainn

September 22, 2008 at 10:38 pm

The Beginning

leave a comment »

Two guys I respect, Justin Kestelyn and Chris Jones at Oracle finally convinced me to maintain a blog. Hopefully, it’ll be interesting and valuable to others experimenting with Oracle technology.

Written by maclochlainn

April 17, 2008 at 4:39 pm

Posted in Generic