Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> extracting unique fields from 2 tables into one new table
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
![]() |
![]() |