Prev: Best way to validate cold datafiles
Next: So who is going to Open World 2010?
From: The Boss on 12 Jul 2010 12:24
On Jul 12, 9:02 am, Carlos <miotromailcar...(a)netscape.net> wrote:
> CAR...(a)XE.localhost> SELECT COUNTRY AS CHAMPION
>   2  FROM FIFA_WORLD_CUP_2010
>   3  WHERE FINAL_RANK=1;
>
> CHAMPION
> --------
> SPAIN
>
> Cheers.
>
> Carlos.
>
> Sorry Sybrand... ;-)

Congrats Carlos.
I hate to say this, but your team deserved to win.

--
Jeroen
From: Terry Dykstra on 12 Jul 2010 13:38
"The Boss" <nltaal(a)baasbovenbaas.demon.nl> wrote in message
news:d7d8de29-50e8-48bf-9208-5b0eb0585dc7(a)d37g2000yqm.googlegroups.com...
On Jul 12, 9:02 am, Carlos <miotromailcar...(a)netscape.net> wrote:
> CAR...(a)XE.localhost> SELECT COUNTRY AS CHAMPION
> 2 FROM FIFA_WORLD_CUP_2010
> 3 WHERE FINAL_RANK=1;
>
> CHAMPION
> --------
> SPAIN
>
> Cheers.
>
> Carlos.
>
> Sorry Sybrand... ;-)

Congrats Carlos.
I hate to say this, but your team deserved to win.

--
Jeroen

Yes, Spain was the better team. "Oranje boven" became "Oranje onder".

--
Terry Dykstra


From: Walt on 12 Jul 2010 16:00
Carlos wrote:
> CARLOS(a)XE.localhost> SELECT COUNTRY AS CHAMPION
> 2 FROM FIFA_WORLD_CUP_2010
> 3 WHERE FINAL_RANK=1;
>
> CHAMPION
> --------
> SPAIN

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

//Walt
From: Kay Kanekowski on 13 Jul 2010 01:46
On 12 Jul., 22:00, Walt <walt_ask...(a)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
>
> //Walt

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;

Are there different results if you change the nls_territory ?

regards
Kay
From: Walt on 13 Jul 2010 10:25
Kay Kanekowski wrote:
> On 12 Jul., 22:00, Walt <walt_ask...(a)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
First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: Best way to validate cold datafiles
Next: So who is going to Open World 2010?