Oracle 10G onwards, the set operator MEMBER OF can be applied to test if an element exists in a collection or not. You do not need to loop through all elements in the collection to find a match.
Follow these ten data modeling guidelines to make sure that your application database design is accurate, usable and scalable.