I am struggling with looping all schemas in Oracle. What I need to achieve is as shown below
But the issue is, that it will iterate till step 5 and when all the iterations are done, it moves to step 6. I want to add step 6 and more in the iterations so that it will run for 1 schema at a time.