Distinct clause causing error

From: Malh1156 <malh1156_at_aol.com>
Date: 1997/02/20
Message-ID: <19970220230200.SAA08198@ladder02.news.aol.com>#1/1

hi,
 The following select statement is not working..      

SQL> insert into mm_list_item(list_id, list_quan,upc)   2 select 10000495, 1,distinct upc
  3 from mm_order_item
  4 /
 select 10000495, 1,distinct upc

                              *

ERROR at line 2:
ORA-00936: missing expression

Is there an alternative to using distinct clause.. thanks in advance,
Malhotra. Received on Thu Feb 20 1997 - 00:00:00 CST