Re: Rows NOT found in cursor search

Thanks for all of your contributions. I was actually after an answer more
closely related to a MERGE statement in which I can have the opportunity to
query the found and NOT found event.

While the engine is searching I can assume that a cursor search is not able
to return a condition of NOT found.

Of course I built a table with the literal values and over that table I
built a cursor, which is very trivial. But my intention was to investigate
whether the task of a cursor could give a hand in reporting a NOT found
condition.

A MERGE can do that with the WHEN MATCHED and the WHEN NOT MATCHED
condition is met for every row in interest, but it's more elaborate (not so
hard either) than a simple cursor search.

Thanks.

JS