Voting
Category
real language
Bookmarking
Language SQL
(Oracle, DBA Version)
| Date: | 02/03/07 |
| Author: | Thomas Rein |
| URL: | n/a |
| Comments: | 0 |
| Info: | n/a |
| Score: |
SELECT CASE bottels WHEN 0 THEN 'No more bottle of beer on the wall, no more bottles of beer. Go to the store and buy some more, 99 bottles of beer on the wall.' ELSE bottels || ' ' || thebar || ' ' || lessbottels END FROM (SELECT rownum -1 bottels, decode(rownum, 1, 'bottle', 2, 'bottle', 'bottles') || ' of beer on the wall ' || to_char(rownum -1) thebar, decode(rownum, 1, 'bottle', 2, 'bottle', 'bottles') || ' of beer. Take one down and pass it around, ' || decode(to_char(rownum -2), 0, NULL, to_char(rownum -2)) || ' ' || decode(rownum -2, 0, 'no more bottles', 1, 'bottle', 'bottles') || ' of beer on the wall.' lessbottels FROM dba_objects WHERE rownum < 101 ORDER BY 1 DESC) /
Download Source | Write Comment
Alternative Versions
| Version | Author | Date | Comments | Rate |
|---|---|---|---|---|
| Self contained Oracle 9i+ Version | Chris Farmer | 11/10/05 | 0 |  |
| MS SQL 2000 | David Teviotdale | 09/07/05 | 4 | |
| DB2 / ANSI | Kent Olsen | 11/29/05 | 1 | |
| MS-Transact-SQL 8.00 | Karl | 07/06/05 | 0 | |
| standard version | Rob van de Pol | 04/20/05 | 0 | |
| Produces the exact lyrics, ORACLE | Ernst Madsen | 09/23/05 | 0 | |
| DB2, no redundancy, with recursion | Joachim Banzhaf | 05/17/06 | 0 | |
| Oracle 9i+ hierarchical query | Christoph Linder | 11/21/07 | 0 |
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!
Comments