Michael McLaughlin
Rexburg, ID

Hear the Author!
Press to play


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