Re: The SELECT I've been waiting for years...
From: Kay Kanekowski <kay.kanekowski_at_web.de>
Date: Mon, 12 Jul 2010 22:46:36 -0700 (PDT)
Message-ID: <42189960-771d-4201-b54f-18d7a8e23cdd_at_z10g2000yqb.googlegroups.com>
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
>
> //Walt
Date: Mon, 12 Jul 2010 22:46:36 -0700 (PDT)
Message-ID: <42189960-771d-4201-b54f-18d7a8e23cdd_at_z10g2000yqb.googlegroups.com>
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
>
> //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
Received on Tue Jul 13 2010 - 00:46:36 CDT