Oracle identifies the first and last records based on a record in the table

Oracle identifies the first and last records based on a record in the table
My table is: info_m1_tran
First, locate the record rownum In the table. If I sort the record by data_time asc, the value of rownum will remain unchanged,
SQL code select rn from (select t. *, rownum rn from (select * from info_m1_tran order by date_time asc) t) where id = '000000' www.2cto.com to get the rownum value. For example, if it is 8, the three records before and after query are as follows:
SQL code select * from (select a. *, rownum rn from (select * from info_m1_tran order by date_time asc) a where ROWNUM <= 11) where rn> = 5