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

Join and Union examples of related tables to show different SQL and esProc syntax

Join multiple tables with “join”

The SQL…

Continue

Posted by Jim King on October 15, 2014 at 12:02am

profiles in Oracle DBA

I've one question it is related to Oracle DBA, I've just read about password settings in profiles concept, i'm little bit confusing on PASSWORD_REUSE_MAX and PASSWORD_REUSE_TIME, and I understand something about these two topics. I updating here what i'm understand when I was reading about this, so tell me is it right or wrong.

1) PASSWORD_REUSE_MAX: This setting is used for reusing of old passwords. The functionality of this setting is restricts reusing of old password for…

Continue

Posted by Bhagya Raj Katta on October 10, 2014 at 7:21am

Dynamic Performance views-what are they?

A little bit about how exactly Oracle retrieves the information from Dynamic performance views. Read more here : http://suntrupth.blogspot.in/2014/10/dynamic-performance-views-what-are-they.html

Posted by Suntrupth Yadav on October 9, 2014 at 9:30am

Oracle Masters?

Where can I ask my Oracle / PlSQL related doubts from masters ?

Posted by Mohammed on September 24, 2014 at 6:07pm

© 2014   Created by Steve Karam.

Badges  |  Report an Issue  |  Terms of Service