Michael McLaughlin
Rexburg, ID

Hear the Author!
Press to play


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 […]

i-Blazon Prime
Wed, 25 Feb 2015 07:54:50 +0000
I replaced my OtterBox Defender with an i-Blazon Prime case when upgrading to the iPhone 6. It appeared a good option, and for 4 months it was fine. Yesterday, the latch broke and my iPhone fell to the ground as a walked. Fortunately, my iPhone landed flat, the i-Blazon plastic case absorbed the impact, and […]

SQL Server XQuery
Thu, 19 Feb 2015 08:54:45 +0000
I promised my students an example of writing xquery statements in Microsoft SQL Server. This post builds on two earlier posts. The first qualifies how to build a marvel table with source data, and the second qualifies how you can create an XML Schema Collection and insert relational data into an XML structure. You can […]

Insert into XML Column
Wed, 18 Feb 2015 09:22:55 +0000
Working through Chapter 7 of the Querying Microsoft SQL Server 2012 book for Microsoft’s Exam 70-461, I found the XML examples incomplete for my students. I decided to put together a post on how to create: An XML Schema Collection type. A table that uses an XML Schema Collection as a column’s data type. An […]

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