Oracle Database Discussions

Red Hat Linux,

Oracle Database 12c

Hi,

I have to add a new partition every first day each month. The algorithm is as follows

if(day(from sysdate)=1)

int j=1

while(j<13 && j=month(from sysdate))

alter table MOBILE_DATA add partition mobile_data_<year from sysdate>_(j) values less than <?>;

How do I extract the day and month from sysdate?

What should I input as values?

Regards,

Joe