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 -> extracting unique fields from 2 tables into one new table

extracting unique fields from 2 tables into one new table

From: mrj <Carl.Seppanen_at_gmail.com>
Date: 3 Apr 2007 16:56:36 -0700
Message-ID: <1175644596.475975.294310@d57g2000hsg.googlegroups.com>


Hi All,
I'm trying to extract every unique field 'called MESSAGES' that exists in table LDR2 and not in table LDR into a new table UNIQUE (each table has only 2 fields (MESSAGES<CLOB>,ID<NUMBERIC>). We missed some data initially, now the LDR2 has the missing data. I need to get this missing data in LDR2 into the new table . However, I cant seem to run many commands because its a CLOB -datatypes.

I'm Using SQL-PLUS - Oracle9i Release 9.2.0.1.0.

<My query that doesnt seem to be working fully> insert into seebeyond.RAD_MESSAGES_UNIQUE (SELECT seebeyond.RAD_MESSAGES_LDR2.MESSAGES, seebeyond.RAD_MESSAGES_LDR2.ID FROM seebeyond.RAD_MESSAGES_LDR2, seebeyond.RAD_MESSAGES_LDR WHERE seebeyond.RAD_MESSAGES_LDR2.MESSAGES NOT LIKE seebeyond.RAD_MESSAGES_LDR.MESSAGES and (rownum < 33617)) /

-Thanks for any advise,
CarlS Received on Tue Apr 03 2007 - 18:56:36 CDT

Original text of this message

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