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

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 Received on Sat Jul 12 2003 - 01:53:22 CDT