drop table range_t;
create table range_t
(range_col varchar2(8),
t2 varchar2(20))
partition by range (range_col)
(
partition P_20180101 values less than('20180102'),
partition P_20180102 values less than('20180103'),
partition P_MAX values less than(maxvalue)
)
insert into range_t values ('20180101','P_20180101');
insert into range_t values ('20180102','P_20180102');
insert into range_t values ('20180103','P_MAX');
insert into range_t values ('20190101','P_MAX');
select * from range_t partition(P_20180102);
select * from range_t partition(P_MAX);