I have a table below in Teradata which need to be created in oracle. Not sure how this can be converted. Any help would be appreciated.
create table emp
(emp_id number,
emp_name varchar(50),
emp_end_dt date)
primary index (emp_id)
partition by range_n(emp_end_dt between date '2015-04-01' and date '2021-05-31' each interval '1' month, date '9999-12-31' and date '9999-12-31' each interval '1' day)
Thanks in advance.