Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Is there something equivalent to Unix "uniq" in Oracle?

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

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Sat, 12 Jul 2003 10:49:09 +0200
Message-ID: <m4hvgvk875jjfaaf61atpcscohg4m0a13f@4ax.com>


On 11 Jul 2003 23:53:22 -0700, ramon_at_conexus.net (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

distinct

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Jul 12 2003 - 03:49:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US