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: inserting distinct values from another table

Re: inserting distinct values from another table

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sat, 14 May 2005 18:03:29 +0200
Message-ID: <d6578b$641$1@news5.zwoll1.ov.home.nl> 





m.mocha_at_gmail.com wrote:


> I'm not sure why this doesn't work:

> 

> insert into courses (CCode, Title, SCode)

> select distinct CCode, Title, SCode

> from TMPT05

> 

> I still get the ERROR at line 1:

> ORA-00001: unique constraint (SYSTEM.SYS_C003020) violated

> 



Because you already did it - tmpt05 contains
one or more values that are already in courses


-- 
Regards,
Frank van Bortel


Received on Sat May 14 2005 - 11:03:29 CDT












Original text of this message













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