RE: SQL question

From: Speaks, Chuck W. <CSpeaks_at_Lithonia.com>
Date: Fri, 18 Jan 2002 13:21:18 -0800
Message-ID: <F001.003F447E.20020118124027@fatcity.com>

Try this

distinct(delegated_person)

Chuck Speaks
Database Administrator
Lithonia Lighting
770-860-3450
http://www.lithonia.com

-----Original Message-----
Sent: Friday, January 18, 2002 12:51
To: Multiple recipients of list ORACLE-L

Hi i am trying to insert records into a table by selectiog from table 2, i want to insert a sequence,, and the distinct values from table 1 but i get an error:

Query used:
INSERT INTO contacts (cont_id,cont_contact_surname) (SELECT seq_cont.nextval,distinct delegated_person FROM sierras
WHERE delegated_person is not null)

Error;

select seq_cont.nextval,distinct delegated_person

ORA-00936: missing expression

How can i modify the query to obtain the correct results

cheers all.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: iashraf_at_csc.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Speaks, Chuck W.
INET: CSpeaks_at_Lithonia.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------