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 CRIGHTON4 hours ago

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

Added 4 hours ago

1 comment

22 views