Oracle Forms

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!

How to display distinct records in Oracle Forms

NeerajaSep 11 2014 — edited Sep 12 2014

Hello Everyone,

I have a datablock whose query is based on a view. The view selects columns a, b, c and d. I display only columns a, b and c and I use column d to match certain criteria. The view is unique on a, b, c and d columns. So I see duplicate values when I display only a, b and c columns. Is there any way I can display distinct values on a, b and c columns.

I hope I am clear.

TIA,

Neeraja

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 10 2014

Added on Sep 11 2014

#forms, #moved-from-devops

4 comments

2,498 views