KCOUG - Advanced SQL

On January 27th, I will be presenting on Advanced SQL at the Kansas City OUG quarterly meeting.

This presentation covers Analytical Functions and Regular Expressions, two topics that I find very useful, but not well understood. The content is very heavy on actual implementation (about 1/3 of the time is demo). I have been using analytical functions to report on performance metrics for the past few years and have found them to be very useful in minimizing table access and maximizing performance of sometimes complicated queries. I recently used regular expressions to remove multiple white spaces from sql text with a single query instead of a pl/sql loop.

Advanced registration is not required. The exact time has not been set, but it will be in the evening. Check the www.kcoug.org site for updates.