Search

Top 60 Oracle Blogs

Recent comments

June 2015

OT: Update on the Fourth International NoCOUG SQL Challenge (Part III)

Update on the Fourth International NoCOUG SQL Challenge in progress at https://nocoug.wordpress.com/2015/05/11/fourth-international-nocoug-sql-... .
Chris Goerg submitted the following MODEL-clause solution. The use of two measures (named cd and cm) is the key. Both measures are initialized with zero values. The rules change the values of the measures. Cheryl's birthday is the date for which cd = 1 and cm = 1.

with d as (
select unique
extract(month from dateofbirth...(read more)

OT: Update on the Fourth International NoCOUG SQL Challenge (Part II)

Update on the Fourth International NoCOUG SQL Challenge in progress at https://nocoug.wordpress.com/2015/05/11/fourth-international-nocoug-sql-... .
The NoCOUG challenge does not come with a fixed data set such as the 10 dates in the Cheryl’s Birthday problem. Instead contestants are required to solve the problem for all data sets that fit the story.

CREATE TABLE DateOfBirth (DateOfBirth DATE NOT NULL);

Perhaps because of familiarity with the Cheryl’s...(read more)

OT: Update on the Fourth International NoCOUG SQL Challenge (Part I)

Update on the Fourth International NoCOUG SQL Challenge in progress at https://nocoug.wordpress.com/2015/05/11/fourth-international-nocoug-sql-challenge.

The previous NoCOUG SQL challenges (First, Second, Third) were about devising clever algorithms and then trying to code them in a language (SQL) that was not designed for implementing algorithms. The fourth challenge is more about translating a functional specification into relational algebra or calculus  so it’s closer to what SQL is all about.