Use Insert, Update, Delete commands instead of execute immediate
I would prefer if the generated script would use insert/update/delete commands for each records instead of execute immediate.
12
votes
Jeff
shared this idea
-
Allen R. Marshall
commented
PLease provide an example. If Schema Compare is running SQL literals via execute immediate, that is probably not such a good idea given the lack of parameterization (which permits cursor reuse) and the (presumably tiny) risk of SQL injection and so on....