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: |  (2.50 in 4 votes) |
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 |
|---|---|---|---|---|
| Oracle 9i+ hierarchical query | Christoph Linder | 11/21/07 | 0 | |
| DB2 / ANSI | Kent Olsen | 11/29/05 | 1 | |
| MS SQL 2000 | David Teviotdale | 09/07/05 | 4 | |
| MS-Transact-SQL 8.00 | Karl | 07/06/05 | 0 | |
| Self contained Oracle 9i+ Version | Chris Farmer | 11/10/05 | 0 | |
| MS SQL 2005 | Johan Åhlén | 09/28/09 | 1 | |
| CROSS JOIN - UNPIVOT - SQL SERVER 2008 | Nick Jacobsen | 09/18/11 | 0 | |
| standard version | Rob van de Pol | 04/20/05 | 0 | |
| DB2, no redundancy, with recursion | Joachim Banzhaf | 05/17/06 | 0 | |
| Produces the exact lyrics, ORACLE | Ernst Madsen | 09/23/05 | 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