How to use sysdate-1 on plsql partition

Hi experts,

I need your support on how to use sysdate-1 on plsql partition?

I am using the following select statement which is working perfectly fine. the partition is being made on a daily level. but I need to make a procedure which runs automatically and change the partition on day -1 and saves the data in a specific path.
partition format is like MSC_CDR_20191021.

Please help on out on how to solve this issue.

Thank you.

Hi, this is a SQL Server forum. Someone here might decide to help, but it would be better to post to a PL/SQL forum. Good luck.