Mclaughlinsoftware - blog.mclaughlinsoftware.com - MacLochlainns Weblog
General Information:
Latest News:
DBMS_COMPARISON Missing? 14 Aug 2013 | 01:18 pm
The dbms_comparison package isn’t deployed when you provision a pluggable databases (PDBs) in Oracle 12c. It appears to be a simple admission. At least, it let me manually compiled the dbms_comparison...
Provision Oracle 12c PDB 13 Aug 2013 | 12:51 pm
Somebody wants help provisioning a pluggable database (PDB). While it’s a new concept in the Oracle 12c database, I can sympathize with their plight. It wasn’t clear to me when first working with it, ...
Convert LONG to CLOB 7 Aug 2013 | 10:56 am
A friend asked me how to get an Oracle view definition out of a LONG column and into a web application. I thought it was an interesting question because I ran into a similar problem when writing the O...
Oracle 12c on Windows 7 27 Jul 2013 | 01:15 am
Here are step-by-step instructions for installing Oracle Database 12c Release 1 on Windows 7. This is more or less to install a Desktop version of Oracle 12c. I posted other versions for Oracle Databa...
Site Blocked in Russia? 15 Jul 2013 | 07:13 am
This is either too funny or too sad. An acquaintance sent me this image from a cyber cafe or hotel in Russia. It says that my blog site is prohibited and violates Russian law, and that they’re blocki...
SQL Like Comparisons 14 Jul 2013 | 12:12 am
SQL tidbits are always valuable and highly searched for by newbies (as opposed to reading the SQL documentation). Sometimes we seasoned SQL developers take for granted little things like when a single...
Oracle OpenWorld 2013 13 Jul 2013 | 10:34 pm
I registered yesterday for Oracle OpenWorld 2013, and I’ll look forward to seeing friends there. Having worked in the Oracle 12c beta for a year, I’ll be interested in the presentations. Also, hearing...
PHP PL/SQL Function Return 28 May 2013 | 11:36 pm
Somebody wanted an example of how to capture the return value of a PL/SQL function in a PHP script running against the Oracle Database. The trick is embedding the call inside an anonymous block progra...
PHP Database Class 24 May 2013 | 10:25 am
PHP namespaces are new to PHP 5.3 (2012), but PHP class files have been around since PHP 5 was introduced. However, a couple students had problems creating working code from the many fragments publish...
MySQL Book in Chinese 24 May 2013 | 08:58 am
One of my old students and lab assistants stopped by to show his fiancée the BYU-Idaho campus. It was a long trip since he lives in Macao, China. He kindly brought me a copy of my Oracle Database 11g ...
