Michael McLaughlin
Share on Facebook
Share

Michael McLaughlin's Friends

  • Prasanna  Kumar Sahu
  • Darryle Pfauntsch
  • Lisa McClain
  • hume
  • Amitanshu Nayak
  • John Harper
  • Robert G. Freeman
  • Mike Bowers
  • Krishna Nujella
  • Newton Fletcher
  • Cindy Conlin
  • Christopher Jones
  • Kuassi Mensah
  • Shiva
  • Alan Shook
 

Michael McLaughlin's Page

Latest Activity

Michael McLaughlin left a comment for John Harper
"You're already a member. Or, did you forget?"
Oct 12, 2011
Michael McLaughlin posted a blog post

Finished a book on Oracle and MySQL

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.See More
Oct 1, 2011
Michael McLaughlin received a gift from Eddie Awad
Nov 18, 2009
Michael McLaughlin and Prasanna Kumar Sahu are now friends
Jul 18, 2009
Michael McLaughlin posted a blog post

Curiousity on Latent LOB Columns

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,…See More
Jul 16, 2009
Michael McLaughlin left a comment for mohit
"Sure, I sent you an email. :-)"
Mar 24, 2009
Michael McLaughlin posted blog posts
Mar 22, 2009
Michael McLaughlin left a comment for mohit
"Mohit, I apologize for the delay in replying, but you got great advice. I think Laurent's is the best starting point - download and play with it. After experimenting with the install, SQL, PL/SQL, RMAN, and OEM, I'd recommend you pick the…"
Mar 22, 2009

Profile Information

About Me:
I teach database technology at BYU – Idaho in the Computer Information Technology Department. I worked at Oracle Corporation for over eight years. While at Oracle, I worked in consulting, development, and support. I created the ATOMS transaction architecture during my doctoral studies (US Patents #7,206,805 and #7,290,056). The patents are assigned to Oracle Corporation. Prior to Oracle, I worked as an Oracle developer, systems and business analyst and DBA beginning with Oracle 6. I'm the author of Oracle Database 11g PL/SQL Programming, Oracle Database 10g Express Edition PHP Web Programming, and co-author of Oracle Database AJAX & PHP Web Application Development, Oracle Database 10g PL/SQL Programming and Expert Oracle PL/SQL.
My Blog:
http://blog.mclaughlinsoftware.com
My Website:
http://www.techtinker.com

Michael McLaughlin's Blog

Finished a book on Oracle and MySQL

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.

Posted on October 1, 2011 at 7:42pm

Curiousity on Latent LOB Columns

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

Posted on July 16, 2009 at 11:57pm

Blog'n courtesy - provide print.css

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

Posted on March 22, 2009 at 8:06am

Pipelined Table Functions Examples

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

Posted on March 22, 2009 at 7:47am

My blog address has changed

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

Posted on November 1, 2008 at 6:33pm

Comment Wall (1 comment)

You need to be a member of Oracle Community to add comments!

Join Oracle Community

At 8:28pm on November 18, 2009, Eddie Awad gave Michael McLaughlin a gift
Gift
Congratulations for your Oracle ACE award. Very well deserved.
 
 
 

Oracle Community On

I'm not a fan of advertising, and so I will not be including any advertisements on OracleCommunity.net. However, managing this community does not come without cost! If you are willing to donate to help pay for the monthly community fees and domain services I accept Bitcoin and PayPal donations.

Donate Bitcoins

Badge

Loading…

Blog Posts

Do What You Do Best and Outsource the Rest

One of the most valuable assets of an organization, data lies at the heart of business. It impacts everything from customer service to email deliverability and ultimately revenue generation. If the data that you have is not accurate, it will have a direct impact on your company’s ability to meet…

Continue

Posted by Alvaro Dee on February 7, 2017 at 2:07am

Draw Actionable Insights and Make Better Decisions with Data Mining Services

Data Mining is the process of analyzing and extracting crucial information from a database and presenting the same in an appropriate way to help business cut cost and boost revenue. In simple words it is the process of drawing crucial and actionable insights, which is imperative for better decision making.

Data mining is crucial for effective management of your business. It is also used for verifying whether or not the strategies are going as planned so as to provide desired results.…

Continue

Posted by Alvaro Dee on February 1, 2017 at 4:02am

Attain Data Accuracy, Competitive Pricing, and Quick Turnaround Time by Outsourcing Data Entry Services

In order to focus on crucial business activities, organizations worldwide prefer outsourcing data entry services to reliable service providers. Though redundant but highly crucial, data entry still remains an important component of document management and requires vigorous quality checks. Outsourcing data entry tasks to experts ensures affordable and quality output while saving time and resources that can be…

Continue

Posted by Alvaro Dee on January 31, 2017 at 4:49am

Present and Exchange Documents Reliably With Portable Document Format

Are you having data in large volumes that needs to be converted from hard copy to PDF format? Can you imagine how much time it would take you to manually convert this data? Well, if you know, then what’s the point of putting in lot of efforts and time?

With the help of PDF data entry services, this task can be made a lot easier. Data entry experts can help you save time and efforts…

Continue

Posted by Alvaro Dee on January 25, 2017 at 3:38am

© 2017   Created by Steve Karam.   Powered by

Badges  |  Report an Issue  |  Terms of Service