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

Verify and Fix Corruption in Oracle Databases, Efficiently

Oracle database system stores massive amounts of data, aiming for secure data storage and management. With a number of predefined queries, this database system lets you insert and retrieve data that is stored in multiple tables inside it. For smoother functioning of a database system and its respective databases, your machine must be free of every single issue that is supposed to cause adverse effects on the data. For…

Continue

Posted by Mark Willium on June 3, 2014 at 11:00pm

esProc Enables Oracle JDBC to Speed Up Retrieve Process

Recently, a performance issue occurs in a big detail report, where the original data volume in the two data tables as it involves has exceeded 3 million rows; the data volume that the report can retrieve after filtering remains at round 2 million rows. As we expected before, by using paged retrieve method, this report would present a much higher performance. However, for the fact that the user also needs to…

Continue

Posted by Jim King on May 29, 2014 at 7:00am

Oracle DBaaS in Private Database Cloud workshop

Designing Database as a Service (DBaaS) in own Database Cloud is very comprehensive topic and it requires a lot of things: clear concept and strategy, solid planning, important architecture decisions, considerable involvement of different stakeholders, extra budget, etc. To start talking about this topic I’ll give my own definition of DBaaS which is a managed database service, hosted and offered by DBaaS provider on pay-per-usage basis, which provides access to own database resource with…

Continue

Posted by Kirill Loifman on May 5, 2014 at 12:37am

© 2014   Created by Steve Karam.

Badges  |  Report an Issue  |  Terms of Service