Hi All,
I have a table in two different schemas with different records. I want to identify the records which are duplicate between the two tables.
The create script is as below:
CREATE TABLE "CIMPROD_FINAL"."SEC_DCVAR"
( "SECS_EQUIPMENT_TYPE" VARCHAR2(8 BYTE) NOT NULL ENABLE,
"VARIABLE_NAME" VARCHAR2(50 BYTE) NOT NULL ENABLE,
"DESCRIPTION" VARCHAR2(255 BYTE),
"EQUIPMENT_GROUP" VARCHAR2(35 BYTE),
"RECIPE_GROUP" VARCHAR2(35 BYTE),
"ENABLE_FLAG" VARCHAR2(1 BYTE),
"UOM" VARCHAR2(10 BYTE),
"LOWER_THRESHOLD" VARCHAR2(35 BYTE),
"UPPER_THRESHOLD" VARCHAR2(35 BYTE),
"LOWER_SPEC_LIMIT" VARCHAR2(35 BYTE),
"UPPER_SPEC_LIMIT" VARCHAR2(35 BYTE),
"RVID" NUMBER(12,0),
"CREATION_USER_ID" VARCHAR2(12 BYTE) NOT NULL ENABLE,
"CREATION_DATE" DATE NOT NULL ENABLE,
"MODIFIED_USER_ID" VARCHAR2(12 BYTE),
"MODIFIED_DATE" DATE,
"VID2" NUMBER(9,0),
"ACTION_CODE" VARCHAR2(16 BYTE) NOT NULL ENABLE,
"DATA_TYPE" CHAR(3 BYTE),
"DELAYS" NUMBER(3,0),
"COLL_NUM" VARCHAR2(8 BYTE) DEFAULT '1',
"CHART_FLAG" VARCHAR2(1 BYTE) DEFAULT 'N',
"SPACE_GROUPING" VARCHAR2(40 BYTE),
"SPACE_TEMPLATE" VARCHAR2(40 BYTE),
"RECPGRP_ID" VARCHAR2(20 BYTE),
"DEVGRP_ID" VARCHAR2(20 BYTE),
"PROCGRP_ID" VARCHAR2(20 BYTE),
"STGGRP_ID" VARCHAR2(20 BYTE),
"CUSTGRP_ID" VARCHAR2(20 BYTE),
"LOTGRP_ID" VARCHAR2(20 BYTE),
"DELAY_TOLERANCE" NUMBER(3,0) DEFAULT 0,
CONSTRAINT "SEC_DCVAR_UNIQUE" UNIQUE ("SECS_EQUIPMENT_TYPE", "VARIABLE_NAME", "EQUIPMENT_GROUP", "RECPGRP_ID", "DEVGRP_ID", "PROCGRP_ID", "STGGRP_ID", "CUSTGRP_ID", "LOTGRP_ID")
There is possibility that there could be NULL in the columns => "RECPGRP_ID", "DEVGRP_ID", "PROCGRP_ID", "STGGRP_ID", "CUSTGRP_ID", "LOTGRP_ID"
Please let me know the query to identify the identical/duplicate records between these two tables in different schemas.
Thanks!