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.