Cacher is the code snippet organizer for pro developers

Select limited rows from Oracle From http://www.oracle.com/technetwork/issue-archive/2006/06-sep/o56asktom-086197.html

select * 
  from t 
 where ROWNUM > 1;