Home Inserting new rows to the table used for cursor, inside the cursor
Reply: 0

Inserting new rows to the table used for cursor, inside the cursor

user580
1#
user580 Published in May 27, 2018, 3:38 am

I am looping through the rows of a temporary table using cursor and inside the cursor I am inserting new rows to the same table used for cursor.

What behaviour I have noticed is that the cursor doesn't include new rows that gets added within the cursor. For my requirement this is what I wanted but I am not sure the behavior I am noticing is correct because my query is complex and I don't know if it can fail later if my observation of the behaviour is wrong.

So doesn't cursor consider rows of the table that was added later inside the cursor?

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.312154 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO