Question I have to execute 20+ static insert queries in procedure (which will be executed by a java scheduler).
I want to store these queries in a oracle table and populate a data structure in Procedure. This datastructure will get executed in a loop and would execute each query one by one.
Can you suggest an approch to implement this in an optimized manner
Thanks Ahead...
Answer Hi there.
A good and common approach is to create a table with a blob column.
When you perform the loop, call the values of the blob with a execute immediate.
