SQL Language (MOSC)

MOSC Banner

cursor () and exists ()

edited Oct 14, 2013 8:00PM in SQL Language (MOSC) 4 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center