Avatar of WAS
WAS
Flag for United States of America

asked on 

for loop for sql

for loop for executing multiple select statements, like i have 70 sql views in my oracle db, i update them and push them to rnd,uat,qa,prod servers, i need to "For loop " script will just execute select * from papa.view1; select * from papa.view2; select * from papa.view3; select * from papa.view4;.................select * from papa.view70;
like above.

Thank you for helping me.
Oracle Database* Oracle PL/SQLSQL

Avatar of undefined
Last Comment
WAS

8/22/2022 - Mon