Oracle分页查询sql语句

1. select * from ( select  t.*, rownum RN from TABLE_NAME  t ) where RN > 0 and RN <= 15

2. select * from ( select  t.*, rownum RN from TABLE_NAME  t ) where RN between 1 and 15