Originally posted by nishant
select * from table_name where rownum <=100;
take care,
Nishant.
Wait a second now! How do we define first and last record of an Oracle table? If you mean last record inserted, there is no way to get it unless you programatically keep a field storing this information.