Re: SQL Fun Challenge #2

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:c26vr5$r93$1_at_titan.btinternet.com...

> The other thing I've done is
> rewrite the approach to use some trendy 9i bits -

S-w-e-e-e-e-e-e-t!
I was reminded of those who claim SQL and relational databases are not flexible and powerful enough to provide realistic solutions to data manipulation problems...

> Of course, I've failed the test, because I didn't
> create, or load, a table with data; I only wrote
> the SQL statement.

You may have failed the ORIGINAL test, but the one suggesting a single SQL WITHOUT tables was passed with flying colours.

Of course, I wanna see a full 10046 of that 9i SQL... :)

-- 
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam