Voting

Category

real language

Bookmarking

Del.icio.us Digg Diigo DZone Earthlink Google Kick.ie
Windows Live LookLater Ma.gnolia Reddit Rojo StumbleUpon Technorati

Language SQL

(Produces the exact lyrics, ORACLE)

Date:09/23/05
Author:Ernst Madsen
URL:n/a
Comments:0
Info:n/a
Score: (1.67 in 3 votes)
/*
  Made for Oracle SQL.
  To be executed at SQL-prompt.
  Replace "your_table" with name of table or view holding at least 100 rows
*/
 set pagesize 310
 set heading off
 set feedback off
 
 select decode(rownum,100,'No more',to_char(100-rownum))||
        'bottle'||decode(rownum,99,'','s')||
        ' of beer on the wall, '||
        decode(rownum,100,'no more',to_char(100-rownum))||
        ' bottle'||decode(rownum,99,'','s')||
        ' of beer.'||chr(10)||
        decode(rownum,100,'Go to the store and buy some more, ',
                          'Take one down and pass it around, ')||
        decode(rownum,99,'no more',to_char(decode(rownum,100,99,99-rownum)))||
        ' bottles of beer on the wall.'
 from your_table
 where rownum<=100;

Download Source | Write Comment

Alternative Versions

VersionAuthorDateCommentsRate
Oracle 9i+ hierarchical queryChristoph Linder11/21/070
Self contained Oracle 9i+ VersionChris Farmer11/10/050
DB2 / ANSIKent Olsen11/29/051
MS SQL 2000David Teviotdale09/07/054
MS-Transact-SQL 8.00Karl07/06/050
MS SQL 2005Johan ┼hlÚn09/28/091
CROSS JOIN - UNPIVOT - SQL SERVER 2008Nick Jacobsen09/18/110
standard versionRob van de Pol04/20/050
Oracle, DBA VersionThomas Rein02/03/070
DB2, no redundancy, with recursionJoachim Banzhaf05/17/060

Comments

Download Source | Write Comment

Add Comment

Please provide a value for the fields Name, Comment and Security Code.
This is a gravatar-friendly website.
E-mail addresses will never be shown.
Enter your e-mail address to use your gravatar.

Please don't post large portions of code here! Use the form to submit new examples or updates instead!

Name:

eMail:

URL:

Security Code:
  
Comment: