an interesting topic

[debasisdas]

question is not advantage of dynamic sql but in such case i mentioned which is appropriate?

Use dynamic sql when the anme of the objects are not known in advance and passed only at runtime.