If I have a series of Insert statements within a loop in a function on the same table. Would an Insert be able to see the values of previous insert in that table ? I just wanted to know, when would the records be committed, as in, is it after the whole function is done for with its execution or right after one single insert.
Right now what I'm observing is that all the inserts are committed after the whole function is executed and one insert doesn't see the value of its previous insert. In this scenario, how can an insert see the value of its previous insert even though the whole transaction that lies within the function is not complete.