Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Forms 4.5 - Unique Records
A way to do this is to use the where clause property of the block.
In the where clause put something like:
rowid in (
select min(rowid)
from <same_table>
group by <cola>, colb>, etc)
<same_table> is the table on which the block is based. <cola> etc are the columns which define each distinct group of records.
HTH
Geoff
KRM wrote:
> Hello.
>
> How would I set up my block so that it only pulls in unique rows of
> data? For instance, in one case, there are 8 rows in the database
> (which are all different from each other), but the fields that I am
> pulling in are not unique, in fact, there are only 2 different sets of
> data. How can I set up the block to disregard the duplicates?
>
> Thanks,
> KRM
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Nov 24 1999 - 20:55:12 CST