Re: Syntax for simple (?) pivot with MODEL clause

From: <>
Date: Mon, 13 Aug 2007 14:22:19 -0700
Message-ID: <>

[Quoted] [Quoted] OK, I'm back. No emergencies today.

Our data changes on a daily, weekly and monthly basis. So, hardcoding values is not an option.

CASE and DECODE would require hardcoding; that you know exactly what the values will be. If new rows with new and different values were entered into the field, you would have to re hardcode the query.

I had looked at PSOUG actually.

Where at least some of the examples were the same as from:

Both examples required hardcoding the value:

RULES (sales['Bounce', 2005] = 100 + MAX(sales)['Bounce', year BETWEEN 1998 AND 2002])

ie. 'BOUNCE', refers to product = 'BOUNCE'

With 10G's new features, is it possible to do this kind of thing, dynamically getting a different number of columns back? In particular with the MODEL clause?

Perhaps a new feature in Oracle 11?

What is the secret please? Received on Mon Aug 13 2007 - 23:22:19 CEST

Original text of this message