Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Multiple values
SELECT distinct TO_CHAR(OBJECT_DBID) OB_DBID
FROM CFG_APP_OPTION ORDER BY OB_DBID ASC
"James Alger" <james.alger_at_bt.com> wrote in message
news:9p9h7j$amo$1_at_pheidippides.axion.bt.co.uk...
> Could anybody tell me if there is a way of ensuring that each item of data
> is displayed only once in an SQL querie.
>
> I currently have the following querie:
> SELECT TO_CHAR(OBJECT_DBID) OB_DBID
> FROM CFG_APP_OPTION
> ORDER BY OB_DBID ASC
>
> However, when I execute it I get the following (Row is just for reference)
> (Row) VALUE
> (1) 101
> (2) 101
> (3) 101
> (4) 102
> (5) 102
> (6) 103
> (7) 104
> (8) 104
>
> What I need it to do is :
> (Row) VALUE
> (1) 101
> (2) 102
> (3) 103
> (4) 104
>
> Does Anyone have any ideas?
>
>
Received on Mon Oct 01 2001 - 06:40:46 CDT