Return Styles: Pseud0ch, Terminal, Valhalla, NES, Geocities, Blue Moon.

Pages: 1-

SQL looks harder than Prolog

Name: Anonymous 2013-02-18 12:15

http://c2.com/cgi/wiki?FizzBuzzTest



select decode(level, trunc(level / 15)*15, 'fizzbuzz', trunc(level/3)*3, 'fizz', trunc(level/5)*5, 'buzz', level) from dual connect by level <= 100;

how does it work?

Name: Anonymous 2013-02-21 12:44

That's Oracle's SQL dialect, it can be rewritten more clearly as:



 select case

           when level = trunc(level/15) * 15 then 'fizzbuzz'

           when level = trunc(level/3) * 3 then 'fizz'

           when level = trunc(level/5) * 5 then 'buzz'

           else level

        end

   from dual

connect by level <= 100;

Name: Anonymous 2013-02-21 12:58

>>2
Thank you.