/*
  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(rown