cursor () and exists ()
We have a query that users CURSOR () and EXISTS(). When the query is run without the EXISTS() clause, it returns seven (7) unique main cursor records. The EXISTS is added with the expectation that is should return one (1) main cursor record, since only one (1) of the seven (7) also matches criteria in the EXISTS() clause. When the EXISTS() clause is added, it does only return the one (1) main cursor record, but it duplicates it four (4) times. The four (4) also happens to be the number of records that would be returned by the EXISTS() clause
0