November 2016

Huge Presentation – Working with Oracle Database in C#, VBScript, and Excel; Enhancing Visual Manufacturing 8.0.0

November 2, 1016 In late September 2016 I gave a somewhat long presentation that lasted roughly four and a half hours.  Surprisingly, the only glitch that I encountered during the live demonstration portion of the presentation was due to an apparent bug, at least in Excel 2010, that causes long object names (specifically checkbox names on […]

Approximate Aggregate Transformation (AAT)

There are situations where approximate results are superior than exact results. Typically, this is the case when two conditions are met. First, when the time and/or resources needed to produce exact results are much higher than for approximate results. Second, when approximate results are good enough. Approximate results are for example superior in case of exploratory queries or when results are displayed in a visual manner that doesn’t convey small differences.

Oracle Database 12.2.0.1 – PL/SQL JSON functionality

One functionality area in Oracle Database 12.2.0.1 that now also supports the handling of JSON…

How you should or shouldn’t design, program for, a performing database environment

My good friend Toon Koppelaars created a cool and very interesting, learning video about how…

"Cost Based Optimizer: Grundlagen – mit Update für Oracle 12c" Artikel (German)

Seit gestern steht auf der "Informatik Aktuell"-Seite mein Artikel "Cost Based Optimizer: Grundlagen – mit Update für Oracle 12c" zur Verfügung.

Er stimmt auch inhaltlich auf meinen Vortrag bei den IT-Tagen 2016 am 13. Dezember ein.
Sollte Sie das Thema interessieren, lade ich Sie hiermit also herzlich zu meinem Vortrag ein, bei dem ich das Thema auch mit Live-Demonstrationen vertiefen werde.

csv.sh

UNIX/Linix shell-script to call the Perl script “csv.pl”, which calls the CSV function in the DUMP_DATA package in PL/SQL.  This is one of the fastest ways to dump data from any Oracle table or table partition to a text file in CSV (comma-separated values) format.

csv.sql

Sample Oracle SQL*Plus script to call the CSV function in the DUMP_DATA package.

csv.pl

Perl script to call CSV function in the DUMP_DATA package.  This is an extremely fast way to dump data from any table or table partition to CSV (comma-separated values) format.

dump_data.sql

PL/SQL package header and specification for extracting data from any specified table or table partition in CSV (comma-separated values) format.

I am now an ex-ACE Director

How apt that this should be my next blog post, following So long, and thanks for all the fish. I’ve been an Oracle ACE Director since 2009, and watched the program evolve in form considerably over that time. It’s always difficult to maintain high quality advocacy as a program grows – my time as part of the OakTable ‘junta’ … Continue reading "I am now an ex-ACE Director"