Here's my CURSOR. In my opinion, Oracle checks for all matching rows, but I want it to check for at least one matching row. In this instance, there are more than 25,000 rows in the concerned table with major criteria:
WHERE company = company_
AND mixed_payment_i d = mixed_payment_i d_
Will not this be a performance killer?
Code:
CURSOR check_trans_type