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:

MySQL bind-address
Mon, 30 Mar 2015 04:30:18 +0000
While I try to keep things simple, sometimes eliminating options and explanations comes back to haunt me. After posting how to open a Fedora firewall port for a LAMP stack, somebody got trapped by my instructions for installing MySQL on Fedora. They got stuck because they had the following setting in their /etc/my.cnf file: bind-address=localhost.localdomain […]


Open Fedora Port 80
Sun, 29 Mar 2015 06:35:44 +0000
After installing the LAMP stack on Fedora, you need to open port 80 in the Firewall to access the PHP programs on the Fedora instance from external servers. You can open a firewall port by launching the firewall-config application as the root user with the following syntax: firewall-config The firewall-config utility opens the following dialog: […]


Fedora Install LAMP
Sun, 29 Mar 2015 01:41:45 +0000
My students wanted an extra credit assignment, so I thought a LAMP configuration and test would be appropriate. The only problem was I hadn’t added it to their course VMware instance. So, here are the instructions to install Apache2, PHP, and MySQLi for a complete LAMP stack when MySQL is already installed. The post builds […]


Lowercase Table Names
Sun, 22 Mar 2015 17:53:42 +0000
A student posed the question about why table names are case sensitive. That’s because case sensitive table names are the default installation, as qualified in the MySQL documentation. You can verify that with the following query: SELECT CASE WHEN @@lower_case_table_names = 1 THEN 'Case insensitive tables' ELSE 'Case sensitive tables.' END AS "Table Name Status"; […]


PostgreSQL Composites
Mon, 16 Mar 2015 08:02:33 +0000
PostgreSQL like Oracle supports record data types but unlike Oracle, PostgreSQL doesn’t support collections of record data types. Here’s an example of how to define a PostgreSQL composite data type, and how to use it as a column’s data type. CREATE TYPE address_type AS ( street_address VARCHAR , city VARCHAR , state VARCHAR , zip_code […]


PostgreSQL Auto IDs
Mon, 16 Mar 2015 03:37:18 +0000
PostgreSQL’s approach to automatic numbering is as simple as Oracle but different than MySQL, and Microsoft SQL Server. For example, you have a two-step process with Oracle, PostgreSQL, MySQL, and Microsoft SQL Server. First, you create an Oracle table with the GENERATED AS IDENTITY clause, a PostgreSQL table with the SERIAL data type, a MySQL […]


 
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