Oracle DB 12.1.0.2
RHEL 7.4
Hello Team,
suppose I have 2 tables A and B. There are some records from B which are not present in A. I would like to know how to insert them in A? B has
insert into A (select * from BWHERE PROCESS_NO_N NOT IN(
select process_no_n from A));
)
DDL A:
CREATE TABLE "MIGR"."A"
( "ACTION_TYPE" VARCHAR2(30 BYTE),
"ACTION_DATE" TIMESTAMP (6),
"SERVICE_ID_V" VARCHAR2(20 BYTE),
"ACCOUNT_LINK_CODE_N" NUMBER(15,0),
"SUB_SERVICE_CODE_V" VARCHAR2(10 BYTE),
"STATUS_DESC" VARCHAR2(50 BYTE),
"PROCESS_NO_N" NUMBER(20,0),
"GCI_RESPONSE" VARCHAR2(200 BYTE),
"ACTION_BY" VARCHAR2(10 BYTE),
"SURVERY" NUMBER(2,0)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "DATA1" ;
insert into A (select * from B WHERE PROCESS_NO_N NOT IN(
select process_no_n from FXLPROV)
)
DDL B:
CREATE TABLE "MIGR"."FXLPROV2"
( "PROCESS_NO_N" NUMBER(20,0)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
Regards,
Joe