CODEWITHSUNDEEP
oracle-adflov
user3395103
user3395103

Reputation: 141

How to avoid duplicate values in a LOV on a adf input table

I have a input table with a LOV field. Values in the LOV are coming from a VO which is join based VO. So key attributes are from all the Eos which are joined. My LOV is defined over one of the key attribute of a EO. So i am getting duplicate values in the LOV due to joins. What can be fix for this ?

Upvotes: -1

Views: 836

Answers (1)

Shay Shmeltzer
Shay Shmeltzer

Reputation: 3721

Did you try introducing the "Distinct" into your query? https://www.techonthenet.com/oracle/distinct.php

Upvotes: 0

Related Questions