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-10-21
Copyright: 2012
More Info


Oracle Database 10g PL/SQL Programming
Published on: 2004-10-07
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:

A PL/pgSQL Function
Thu, 22 Jan 2015 08:03:00 +0000
Somebody wanted to know how to write a basic PostgreSQL PL/pgSQL function that returned a full name whether or not the middle name was provided. That’s pretty simple. There are principally two ways to write that type of concatenation function. One uses formal parameter names and the other uses positional values in lieu of the […]


PL/SQL Fall Through?
Sun, 18 Jan 2015 07:13:18 +0000
Somebody wants to know how you can write a PL/SQL solution that mimics the fall through of a switch statement because PL/SQL doesn’t support a switch statement (it does support a simple and searched CASE statement without fall through). It’s a question that I found interesting because there wasn’t a need for it when I […]


Convert to SQL Server?
Fri, 16 Jan 2015 02:18:34 +0000
I’m always amazed at the questions that pop up for me. For example, how do you convert an Oracle script that creates my Video Store model to a Microsoft SQL Server script. It’s not very hard but there’s one big caveat, and that’s the fact that system_user is a reserved word. That means you can’t […]


Popular Programming Languages
Fri, 02 Jan 2015 04:46:23 +0000
First of all, Happy New Year! IEEE Spectrum published a ranking of the most popular programming languages. Computational journalist Nick Diakopoulos wrote the article. While it may surprise some, I wasn’t surprised to find SQL in the top ten. Nick weighted and combined 12 metrics from 10 sources (including IEEE Xplore, Google, and GitHub) to […]


Querying InnoDB Tables
Sat, 27 Dec 2014 08:18:55 +0000
Somebody ran into the following error message trying to query the innodb_sys_foreign and innodb_sys_foreign_cols tables from the information_schema database: ERROR 1227 (42000): Access denied; you need (at least one of) the PROCESS privilege(s) for this operation It’s easy to fix the error, except you must grant the PROCESS privilege. It’s a global privilege and it […]


MySQL Non-unique Indexes
Wed, 24 Dec 2014 08:14:44 +0000
Somebody wanted to know how to find any non-unique indexes in information_schema of the MySQL. The query takes a session variable with the table name and returns the non-unique indexes by column names. It uses a correlated subquery to exclude the table constraints. A similar query lets you find unique indexes in MySQL. Both queries […]


 
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