Re: Is there something equivalent to Unix "uniq" in Oracle?

Ramon F Herrera wrote:

> Does Oracle have a modifier or function equivalent
> to the "uniq" Unix command?
>
> I need to do something like this across the Internet:
>
> SELECT id FROM hugetable ORDER BY id;
>
> I know that there are lots of repeated values and
> I am trying to reduce the network traffic.
>
> TIA,
>
> -Ramon F. Herrera

As indicated by Sybrand ... you can use DISTINCT as in:

SELECT DISTINCT constraint_type FROM dba_constraints;

but if you are more used to UNIX you can also use:

SELECT UNIQUE constraint_type FROM dba_constraints;

either syntax works.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)