• Hi

    One question: if considering whether to use Cursors or alternatives, how does trigger firing influence the decision?

    I mean, when using a cursor to perform an insert statement with each loop, triggers on the target table will fire for each row being inserted.

    When using alternatives, is there any way to ensure that triggers will process each insert?

    Thanks