Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: extracting unique fields from 2 tables into one new table
On Apr 3, 6:56 pm, "mrj" <Carl.Seppa..._at_gmail.com> wrote:
> 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
MERGE INTO would do nicely for this task, I think.
David Fitzjarrell Received on Wed Apr 04 2007 - 08:29:05 CDT