SELECT * (SELECT Rownum rn, tab1.* FROM tab1) WHERE rn between lower_value and Upper_value;
Tab1 will be the name of the table and lower_value will be the Lower bound and upper_bound will be the Upper bound value .
Its a very basic question but it would be good if anyone can answer with some explanations. When we type select * from dba_users; in sql plus it will show N rows selected and total records whereas when we type select * from employee it would show only records but not the total count.
select * from dba_users;
select * from employee