Re: The SELECT I've been waiting for years...
From: gs <gs_at_gs.com>
Date: Tue, 13 Jul 2010 14:39:08 GMT
Message-ID: <gU__n.9212$z%6.2004_at_edtnps83>
Walt wrote:
> Kay Kanekowski wrote:
>
>
> In order for this to return a result you'd need to increase the size of
> the Flash Prognostication Area by specifying values for the following
> initialization parameter:
>
> * DB_PROGNOSTICATION_FILE_DEST_SIZE
>
>
> Unfortunately, in Version 11 you are limited to approximately 7 days of
> flash-forward. Perhaps V 12 will allow this level of flash forward, but
> I'm not sure. I am certain that the query will return valid results by
> the time v13 is out.
>
> //Walt
Date: Tue, 13 Jul 2010 14:39:08 GMT
Message-ID: <gU__n.9212$z%6.2004_at_edtnps83>
Walt wrote:
> Kay Kanekowski wrote:
>> On 12 Jul., 22:00, Walt <walt_ask..._at_SHOESyahoo.com> wrote:
>>> You could have gotten this result earlier using the OCTOPUS module (new
>>> in version 11)
>>>
>>> SELECT OCTOPUS.get_winner('FIFA', 'FINAL', '2010') as CHAMP from dual;
>>>
>>> CHAMP
>>> --------
>>> Spain
>
>> Hi Walt,
>> sorry, but i havn't a version 11. So what is the result of
>>
>> SELECT OCTOPUS.get_winner('FIFA', 'FINAL', '2014') as CHAMP from
>> dual;
>
> In order for this to return a result you'd need to increase the size of
> the Flash Prognostication Area by specifying values for the following
> initialization parameter:
>
> * DB_PROGNOSTICATION_FILE_DEST_SIZE
>
>
> Unfortunately, in Version 11 you are limited to approximately 7 days of
> flash-forward. Perhaps V 12 will allow this level of flash forward, but
> I'm not sure. I am certain that the query will return valid results by
> the time v13 is out.
>
> //Walt
Rumor has it that Larry is thinking about branding the next release as 12O - which boasts the new 8 process analytical engine.. Received on Tue Jul 13 2010 - 09:39:08 CDT