Chet Justice ORACLENERD T-Shirts Recently I was asked to create some merchandise that fell outside of my norm. Specifically, I was asked to create... 20 September 2011 2 min read
Alex Nuijten How Long is this String? A quick puzzle from Alex Nuijten’s blog: How long is the folowing string?: to_char (10, ‘0999’) Have a think, and... 15 September 2011 1 min read
Jim Tilson Writing Better Dynamic SQL Dynamic SQL is a powerful tool. In its proper place it can achieve quite a bit of work in a... 14 September 2011 7 min read
Geoff Hudik Red Gate Schema Compare for Oracle Review From Geoff Hudik’s blog. As part of my recent role in application release management, I have had to compare and... 13 September 2011 2 min read
David Njoku Introduction to Regular Expressions in Oracle Regular expressions – RegEx or RegExp to their friends – were fashionably late in coming to the Oracle party. The... 06 September 2011 5 min read
Patrick Barel Collections in Oracle Part 2 “The process of learning requires not only hearing and applying but also forgetting and then remembering again.” John Gray. This... 02 September 2011 6 min read
Alex Nuijten Business Rule: Only One per Day, but Keep the Time The business rule states: Only one entry is allowed per ID and per day and the time should be recorded.... 30 August 2011 1 min read
Cary Millsap Mastering Oracle Trace Data A one-day course taught by Cary Millsap London, UK, 8 Sept 2011 Oracle trace data is an extraordinarily rich information... 19 August 2011 1 min read
Patrick Barel Collections in Oracle Part 1 “The beginning of knowledge is the discovery of something we do not understand.” Frank Herbert. Collections are single-dimensioned lists of... 19 August 2011 5 min read
Chris Hritzuk Can PL/SQL be Faster than SQL? PL/SQL and SQL both are incredibly powerful languages that allow us to do some pretty amazing things with data. If... 19 August 2011 11 min read
David Njoku Autonomous Transactions in Oracle Autonomous transactions are a bit like that dark part of the forest, beyond the rickety bridge, where the shadows are... 18 August 2011 6 min read
Patrick Barel Working with Table Functions in PL/SQL Table functions are functions that produce a collection or rows (either a nested table or a varray) that can be... 20 July 2011 2 min read
