APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Duplicates in Collections

GUS CRIGHTONNov 10 2025

Apex 24.2

I have a barcode application that inserts into an Apex Collection.

I can show a report if there are any duplicates using

SELECT c001, COUNT(*)
from apex_collections
where collection_name = '*****'
GROUP BY c001
HAVING COUNT(*) > 1
order by COUNT(*) desc;

Is there anyway I can populate a page item with Yes or No, if there are duplicates in the the collection.

I can then use this item to show or hide certain page items

Regards

Gus

This post has been answered by L. Fernigrini on Nov 10 2025

Jump to Answer

Added on Nov 10 2025

2 comments

101 views