Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select * from V$VERSION;


BANNER
BANNER_FULL
BANNER_LEGACY
CON_ID


Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
0


create table t(x int, name varchar(100))
insert 
  into t
 select level,case when mod(level,2)=0 then 'CDR' else 'SDS' end as col2
   from dual
 connect by level<=10000
10000 rows affected

select *
  from t
 order by name offset 1 rows fetch next 10 rows only


X
NAME


1706
CDR

1704
CDR

1702
CDR

1700
CDR

1698
CDR

1696
CDR

1694
CDR

1692
CDR

1690
CDR

1688
CDR


select *
  from t
 order by name offset 11 rows fetch next 10 rows only


X
NAME


1706
CDR

1704
CDR

1702
CDR

1700
CDR

1698
CDR

1696
CDR

1694
CDR

1692
CDR

1690
CDR

1688
CDR

X	NAME
1706	CDR
1704	CDR
1702	CDR
1700	CDR
1698	CDR
1696	CDR
1694	CDR
1692	CDR
1690	CDR
1688	CDR