The SELECT I've been waiting for years...

#1

CARLOS (AT) XE (DOT) localhost> SELECT COUNTRY AS CHAMPION
2 FROM FIFA_WORLD_CUP_2010
3 WHERE FINAL_RANK=1;

CHAMPION
--------
SPAIN

Cheers.

Carlos.

Sorry Sybrand... ;-)

#2

Carlos wrote,on my timestamp of 12/07/2010 5:02 PM:

Quote:

CARLOS (AT) XE (DOT) localhost> SELECT COUNTRY AS CHAMPION
2 FROM FIFA_WORLD_CUP_2010
3 WHERE FINAL_RANK=1;

CHAMPION
--------
SPAIN

Cheers.

Carlos.

Sorry Sybrand... ;-)

LOL!
Rub it in!
Congarats to all the hermanos.
And Puyol is still the best mid-defender I've ever seen, bar none.

#3

Carlos:

Quote:

CAR... (AT) XE (DOT) localhost> SELECT COUNTRY AS CHAMPION
* 2 *FROM FIFA_WORLD_CUP_2010
* 3 *WHERE FINAL_RANK=1;

CHAMPION
--------
SPAIN

Was it just the men in soccer or is there a womens championship game
also?

#4

On 12 Jul., 09:02, Carlos <miotromailcar... (AT) netscape (DOT) net> wrote:

Quote:

CAR... (AT) XE (DOT) localhost> SELECT COUNTRY AS CHAMPION
* 2 *FROM FIFA_WORLD_CUP_2010
* 3 *WHERE FINAL_RANK=1;

Hi,

Congratulation to Spain, you have played the best football. But please
try to score a second goal, or better a third goal ;-)

And next time we will have a better 'oracle': http://en.wikipedia.org/wiki/Paul_%28octopus%29

regards from germany
Kay

#5

On 12 Jul., 12:55, John Hurley <hurleyjo... (AT) yahoo (DOT) com> wrote:

Quote:

Was it just the men in soccer or is there a womens championship game
also?

come to germany next year http://www.fifa.com/womensworldcup/index.html

regards
Kay

#6

On Jul 12, 9:02*am, Carlos <miotromailcar... (AT) netscape (DOT) net> wrote:

Quote:

CAR... (AT) XE (DOT) 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

#7

"The Boss" <nltaal (AT) baasbovenbaas (DOT) demon.nl> wrote

On Jul 12, 9:02 am, Carlos <miotromailcar... (AT) netscape (DOT) net> wrote:

Quote:

CAR... (AT) XE (DOT) 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

#8

Carlos wrote:

Quote:

CARLOS (AT) XE (DOT) 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

#9

On 12 Jul., 22:00, Walt <walt_ask... (AT) SHOESyahoo (DOT) com> wrote:

Quote:

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

#10

Kay Kanekowski wrote:

Quote:

On 12 Jul., 22:00, Walt <walt_ask... (AT) SHOESyahoo (DOT) 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