Michael McLaughlin
Rexburg, ID




Hear the Author!
Press to play



 
EMAIL THIS WRITER:
 
Your Name :
 
 
Your Email :
 
 
Subject :
 
 
Message :

 



AUTHOR BIO:Michael McLaughlin is a professor of Computer Information Technology at Brigham Young University-Idaho.

He is also an Oracle ACE. Mike has worked with the Oracle product stack for 20 years as a developer, DBA, and E-Business Suite Applications DBA. He worked at Oracle for more than eight years in consulting, support, and development, and left the company as Senior Upgrade Manager, Release Engineering for their Applications Division.

Mike is the inventor of the ATOMS transaction architecture (U.S. Patents #7,206,805 and #7,290,056), and is the author of nine books on Oracle technology, including Oracle Database 12c PL/SQL, Oracle Database 11g PL/SQL Programming, Oracle Database 10g PL/SQL Programming Workbook and the Oracle Database 11g & MySQL 5.6.

SERVICES:Developer, DBA, and E-Business Suite Applications DBA


WRITTEN WORKS:

Oracle Database 11g and MySQL 5.5 Developer Handbook
Published on: 2011-09-30
Copyright: 2012
More Info


Oracle Database 10g PL/SQL Programming
Published on: 2004-09-16
Copyright: 2004
More Info


Expert Oracle PL/SQL
Published on: 2005-09-12
Copyright: 2006
More Info


Oracle Database Ajax & PHP Web Application Development
Published on: 2008-02-21
Copyright: 2008
More Info


Oracle Database 11g PL/SQL Programming
Published on: 2008-03-21
Copyright: 2008
More Info


Oracle Database 11g PL/SQL Programming Workbook
Published on: 2010-01-20
Copyright: 2008
More Info



BLOG:

Hiding a Java Source
Wed, 23 Jul 2014 04:23:55 +0000
The ability to deploy Java inside the Oracle database led somebody to conclude that the source isn’t visible in the data catalog. Then, that person found that they were wrong because the Java source is visible when you use a DDL command to CREATE, REPLACE, and COMPILE the Java source. This post discloses how to […]


Visual Studio Freedom
Sat, 05 Jul 2014 07:48:21 +0000
Some of my students want to learn to write C++ on a Windows OS. At some point, you simply surrender to the fact that many people prefer the Windows OS as a starting point. Traditionally, I’d recommend the Microsoft Visual Studio as their learning vehicle because it’s free to our students because of our relationship […]


Fedora VMWare Upgrade
Thu, 03 Jul 2014 08:00:23 +0000
When a new update of VMWare comes out, and it is time to upgrade VMWare Tools. Here’s an update on the instructions for upgrading VMWare Tools: Navigate to the VMWare Menu, choose Virtual Machine and in the drop down menu Install VMWare Tools. This will mount a virtual CD in the Oracle Unbreakable Linux virtual […]


External Table Access
Thu, 19 Jun 2014 07:39:21 +0000
I left to chance where students would attempt to place their external files in a Linux or Unix implementation. As frequently occurs, they choose a location in their student user’s home directory. Any attempt to read an external table based on a file in this type of directory fails because it’s not accessible by the […]


Sequence disallows order by
Mon, 16 Jun 2014 00:20:43 +0000
A call to a PRICE_S1 sequence in a query with an ORDER BY clause is disallowed, which typically occurs in an INSERT statement. Any attempt raises the following exception: SELECT price_s1.NEXTVAL AS price_id * ERROR at line 1: ORA-02287: SEQUENCE NUMBER NOT allowed here You need to remove the ORDER BY clause to eliminate the […]


MySQL Insert from Query
Sun, 15 Jun 2014 06:19:26 +0000
While working with an error that my students surfaced in the Oracle Database 12c, I blogged about the limit of using a subquery in an Oracle INSERT statement, and I discovered something when retesting it in MySQL. It was a different limitation. I was also surprised when I didn’t find any mention of it through […]


 
Author Profile
Name: Michael McLaughlin
Location: Rexburg, ID
Subjects: Applications; Databases; Middleware; Servers;

Website: Oracle Press Books

Copyright © 2013 McGraw-Hill Global Education Holdings, LLC Any use is subject to the Terms of Use and Privacy Notice