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:

Querying an Object Type
Tue, 25 Nov 2014 07:33:34 +0000
I demonstrated a number of SQL approaches to reading object types in Appendix B of the Oracle Database 12c PL/SQL Programming book. For example, the easiest one to construct and return the results from a TO_STRING member function uses the TREAT function: SELECT TREAT(base_t() AS base_t).to_string() AS "Text" FROM dual; However, it seems that I […]


Finding Direct Indexes
Mon, 24 Nov 2014 03:42:16 +0000
If you’re not using Toad DBA Suite, it’s sometimes hard to find solutions. Somebody wanted to know how to find indexes that aren’t indirect. Indirect indexes are those created for a primary key because a primary key column or set of columns are both not null and uniquely constrained. Likewise, you create a unique index […]


Check Constraints
Tue, 21 Oct 2014 06:51:01 +0000
Oracle Database 12c introduces a SEARCH_CONDITION_VC column to the CDB_, DBA_, ALL_, and USER_CONSTRAINTS views. The SEARCH_CONDITION_VC column is a VARCHAR2 data type equivalent to the search condition in the LONG data type SEARCH_CONDITION column. Unfortunately, Oracle Database 11g and earlier versions requires you to convert the LONG data type to a VARCHAR2 for the […]


iPhoto movie export
Wed, 15 Oct 2014 01:15:03 +0000
What happens when iPhoto doesn’t export movies? One of two things, you re-install iPhoto and risk losing the movies and photos; or you drop down to the Terminal level and move the files manually before re-installing iPhoto. Option one is easy, you open iPhoto, choose File from menu, and Export… from the File menu list. […]


Using MySQL Workbench
Thu, 25 Sep 2014 23:10:02 +0000
I’ve been setting up a simplified lab environment to let my students learn use in class. This added content will show them how to do reverse engineering with MySQL Workbench. It’s a complete Fedora image with MySQL and Oracle Database 11g for the course. The uncompressed image is 14GB and the compressed image is 5.3GB. […]


Fedora PostgreSQL Install
Wed, 24 Sep 2014 08:43:42 +0000
Somebody asked how to put PostgreSQL on my Fedora image with Oracle Database 11g and MySQL. It’s fairly simple. You can check for the current download at yum.postgresql.org and then download it like this as the root user: yum localinstall http://yum.postgresql.org/9.3/fedora/fedora-20-x86_64/pgdg-fedora93-9.3-1.noarch.rpm You should see the following output when the download is successful, don’t forget to […]


 
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