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

From: Walt <walt_askier_at_SHOESyahoo.com>
Date: Mon, 12 Jul 2010 16:00:23 -0400
Message-ID: <svK_n.305648$ot7.269908_at_en-nntp-16.dc1.easynews.com>

Carlos wrote:
> CARLOS_at_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 Received on Mon Jul 12 2010 - 15:00:23 CDT