Need help on creating a PROCEDURE that will insert as select to source table from destination table

Job ID: 32918342

Budget: ₹1,500 – ₹12,500 INR

In Oracle Database 19c,
I have a partition table which is the destination table.
I have the insert as select script which will pull data from source table and insert in destination.

I want to create a stored procedure to do the insert as select .

So I need someone who has experience in PL/SQL and Oracle Database.