MacLochlainns Weblog

Publications – Articles

• How to Update Nested Object and Table Columns, Part 1, April 27, 2017
• How to Update Nested Object and Table Columns, Part 2, May 30, 2017
• Tips & Techniques – PL/SQL Object Table Function, January 18, 2017
• Using Python and cx_Oracle, Part 3, Toad World, December 30, 2016
• Using Python and cx_Oracle, Part 2, Toad World, December 26, 2016
• Using Python and cx_Oracle, Part 1, Toad World, October 31, 2016
• How to Compare Stored Objects, Toad World, October 3, 2016
• How to Write a Check Sum for Stored Programs, Toad World, August 31, 2016
• How to Deploy Web Apps with Lookups, Toad World, August 3, 2016
• Database Design Patterns: The Lookup Table, Toad World, July 1, 2016
• How to Create Dynamic PL/SQL Web Pages, May 19, 2016
• How to use DBMS_CRYPTO for Web Apps, May 3, 2016
• External Tables with Preprocessing, April 1, 2016
• Configure Oracle’s XDB Server for Web Applications, February 29, 2016
• Writing Internal Java Libraries and PL/SQL Wrappers, February 4, 2016
• Striping Tables with DBMS_APPLICATION_INFO, December 23, 2015
• Creating a PL/SQL Authentication Function, November 30, 2015
• Using DBMS_JAVA to Read External Files, November 2, 2015
• Using DBMS_LOB to Load Large Objects, September 28, 2015
• Using DBMS_COMPARISON to Synchronize Data, August 24, 2015
• Effectively Using the UTL_FILE Package, August 3, 2015
• Managing SQL Test Cases, June 29, 2015
• Logging Trigger Results, June 1 2015
• Opportunities of the Information Age: Maximizing database/data warehouse performance with Dell Oracle Database Acelleration, May 20, 2015
• Critical and Non-critical Triggers, May 4, 2015
• DML Trigger Basics, April 2, 2015
• Overloading Functions & Procedures, February 26, 2015
• Oracle Type Collections, February 6, 2015
• Object Types and Column Sustainability, December 20, 2014
• Database Design Patterns: The Lookup Table Object types and Subtypes, December 19, 2014
• Object Types & Bodies Basics, September 24, 2014
• Pipelined Table Functions, September 5, 2014
• Identity Columns, July 18, 2014 External Tables, July 1, 2014
• Collections and Nested Tables, June 5, 2014
• Database Authentication for PHP Applications, Part 1, Oracle Technical Network, 2007
• Database Authentication ofr PHP Applications, Part 2, Oracle Technical Network, 2007

Conference Presentations

• Tricks and Techniques with Oracle User Defined Types, UTOUG Training Days 2018, Salt Lake City, Utah
• External Tables – Ground Zero to Expert, UTOUG Training Days 2018, Salt Lake City, Utah
• Automate Database Deployment with Python, UTOUG Training Days 2018, Salt Lake City, Utah
• Soup to Nuts: Writing DML Triggers, UTOUG Training Days 2018, Salt Lake City, Utah
• A Step-by-step Tour of Native Dynamic SQL (NDS), East Coast User Conference, November 2017, Raleigh, North Carolina
• Python & Oracle, UTOUG Training Days 2017 Salt Lake City, Utah
• Step-by-step Oracle Native Dynamic SQL (NDS), UTOUG Training Days 2017, Salt Lake City, Utah
• Development Panel, UTOUG Training Days 2017, Salt Lake City, Utah
• Keynote, 6th International Conference on Information Systems and Technologies, 2016, Barcelona, Spain
• Writing Java I/O Inside Oracle Database 12c, UTOUG Fall Symposium 2014, Salt Lake City, Utah
• Writing PL/SQL Programs in Oracle 12c, UTOUG Training Days 2014, Salt Lake City, Utah
• Oracle Database 12c SQL & PL/SQL New Features, UTOUG Fall Symposium 2013, Salt Lake City, Utah
• Writing Database Triggers, UTOUG Training Days 2013, Salt Lake City, Utah
• Implementing PHP/MySQL Striped Views, UTOUG Training Days 2013, Salt Lake City 2013, Salt Lake City Utah
• A Framework for Managing Imports through External Tables, Oracle OpenWorld 2012, San Francisco, California
• Portable SQL between Oracle and MySQL, UTOUG Fall Symposium 2012Portable SQL between Oracle and MySQL, Collaborate 12, Las Vegas, Nevada
• A Framework for Managing Imports through External Tables, UTOUG Training Days 2012, Salt Lake City, Utah
• Using Collections, PL/SQL, and Java, UTOUG Training Days 2012, Salt Lake City, Utah
• Migrating PL/SQL to MySQL Stored Procedures, UTOUG Training Days 2012, Salt Lake City, Utah
• Integrating MySQL Subroutines for Integrity, O’Reilly MySQL Conference & Expo 2011, San Jose, California
• PL/SQL Web Programming Case Study, UTOUG Training Days 2011, Salt Lake City, Utah
• How Coupling Effects PL/SQL Functions and Procedures, UTOUG Training Days 2011, Salt Lake City, Utah
• Virtual Private Databases, UTOUG Training Days 2010, Salt Lake City, Utah
• Using an Apprenticeship Model in the Classroom, BYU-Idaho Faculty Conference on Learning and Teaching,
• September 2010
• PL/SQL Functions and Procedures in Depth, UTOUG Training Days 2009, Salt Lake City, Utah
• Implementing Java inside the Databases, UTOUG Training Days 2009, Salt Lake City, Utah
• Oracle Database 11g New Features, UTOUG Training Days 2008, Salt Lake City, Utah
• Oracle LOBs: An In-Depth View, UTOUG Training Days 2008, Salt Lake City, Utah
• Using OCI8 to Build OPAL Web Applications, UTOUG Training Days 2007, Salt Lake City, Utah
• Developing Oracle 10g PL/SQL Object Layers over Table Data, UTOUG Training Days 2005, Salt Lake City, Utah
• Using Oracle 10g Object Types Instead of Record and Collection Types, UTOUG Training Days 2005, Salt Lake City, Utah