Team, I am new to procedures and trying to create a procedure to delete entries from tables.
Tables names will be in Query 1
My request_id will be in another query which entries i need to delete.

how do i start a procedure to prepare delete statements now
query_1 o/p Query_2 o/p
Table_1 15
Table_2 23
Table_3 33
my delete statement should be

    delete Table_1 where requet_id in (15,23,33);
    delete Table_2 where requet_id in (15,23,33);
    delete Table_3 where requet_id in (15,23,33);

I tried assigning query_1 o/p to a variable and query_2 o/p to another variable.
but not sure how to prepare delete statement here.