Hallo Harro,

with this query you will get no beer :-)
Try as example:
select * from dual
where rownum > 10;

Or
SHUTDOWN [Email Address Removed] immediate


Monday, March 31, 2003, 12:53:40 PM, you wrote:
HW> SELECT * FROM DRINKS.BEER
HW> WHERE ROWNUM > A LOT
HW> IF ME.TASTE <> 'BEER'
HW> THEN SELECT * FROM DRINKS.WHISKY
HW> WHERE ROWNUM > A LOT;

cu
Wieland mailto:[Email Address Removed]Oracle LazyDBA home page