remark 99 bottles of beer with Oracle SQL*Plus remark R.vandePol@voeding.tno.nl < Rob van de Pol> remark remark assuming that YourTable contains at least 99 rows ;-) remark remark RowNum is an Oracle psuedo column indicating the sequence the rows remark were selected. SELECT TO_CHAR(100-rownum)||' bottles of beer on the wall,