explain plan for
SELECT * FROM (SELECT ROWNUM as nrow, USERNAME,NAME,to_char(STARTDATE,'YYYY-MM-DD') as STARTDATE,to_char(EXPIRYDATE,'YYYY-MM-DD') as EXPIRYDATE FROM USERS u) where nrow >= 100 and nrow <= 200;
select * from table(dbms_xplan.display);