Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sql query to compare source data and load into multiple tables

AmywilsonDec 2 2020

Hi Team,
I have source table with millions of data. Trying to load the data from Source table to Multiple target tables. Before loading need to avoid duplicates. So need to check Matched Records and Unmatched records. If matched then planning to apply UPDATE else Insert the data and trying to delete duplicate records too. Please suggest how to load data from one source table to Multiple Target tables by apply MERGE kind of logic over there.
Source Table
<code>CREATE TABLE SRC_TGT_FILE_LOAD
(Qcare_License_Sfx varchar2(15),
License_Sfx varchar2(15),
v2ID varchar2(15),
Prvdr_NPI varchar2(15),
Last_Name varchar2(30),
First_Name varchar2(30),
MI varchar2(1) ,
TTL varchar2(5) ,
Addr_Line1 varchar2(60),
Addr_Line2 varchar2(60),
Addr_Eff_Dt date,
Addr_Term_Dt date,
Addr_Term_RSN_CD number(8),
New_Prtc_Addr_Term_Dt date,
New_Prtc_Addr_Term_Rsn varchar2(30),
City varchar2(20),
ST varchar2(4),
Zip varchar2(5) ,
Zip_pLUS_4 varchar(10),
Phone varchar2(15),
Phone_Typ varchar2(20),
Fax_Nbr varchar2(15),
Fax_Type varchar2(20),
Email varchar2(30),
Ofc_Schedule varchar2(20),
Website_URL varchar2(30),
V2_Desc_Spclty_Prmry varchar2(60),
V2_Desc_Spclty1 varchar2(30),
V2_Desc_Spclty2 varchar2(60),
V2_Desc_Spclty3 varchar2(60),
Combined_Addr varchar2(60),
Prmry_Pract_Ind varchar2(1),
NETWORK varchar2(20),
NETWORK_Opt_Desc varchar2(60),
Crnt_NETWORK_ID varchar2(12),
Crnt_PAR_Ind varchar2(3),
Crnt_TOF number(3),
Crnt_PCP_Ind varchar2(1),
Crnt_FFS_or_CAP varchar2(3),
Crnt_Mbr_Cpcty_Cnt number,
Crnt_Patient_Gndr_Pref varchar2(6),
Crnt_Age_From number(3),
Crnt_Age_to number(3),
Crnt_Accpt_Ptnt_IND varchar2(30),
Crnt_Direct_Ind varchar2(7),
Crnt_NETWORK_ID_Eff_Dt date,
Crnt_NETWORK_ID_Term_Dt date,
Crnt_NETWORK_Term_Dt date,
Crnt_NETWORK_Term_Rsn varchar2(30),
New_NETWORK_ID varchar2(4),
New_NETWORK_Eff_Dt date,
New_PAR_Ind varchar2(3),
New_TOF varchar2(3),
New_FFS_CAP varchar(3),
New_Mbr_Cpcty_Cnt number(3),
New_Ptnt_Gnder_Pref varchar2(5),
New_Age_from number(3),
New_Age_To number(3),
New_Acpt_Ptnt_IND varchar2(30),
New_Direct_Ind varchar2(8),
Crnt_BM_ID varchar2(8),
Crnt_BM_ID_Eff_Dt date,
Crnt_BM_ID_Term_Dt date,
BM_ID_Term_Dt date,
BM_ID_Term_Rsn varchar2(30),
New_BM_ID varchar2(8),
New_BM_ID_Eff_Dt date,
New_BM_ID_Term_Dt date,
Crnt_TaxID_sfx varchar2(20),
Crnt_Tax_V2 number(8),
Crnt_Tax_NPI number(10),
Crnt_Tax_Grp_Name varchar2(30),
Crnt_TaxID_Lnkd_to_RBM varchar2(18),
Crnt_Affltn_Eff_Dt date,
Crnt_Affltn_Term_Dt date,
Crnt_TaxID_sfx_term_rsn varchar2(30),
New_TaxID_sfx varchar2(15),
New_TaxID_V20_ID varchar2(15),
New_Tax_NPI varchar2(20),
New_Tax_Grp_Nm varchar2(30),
Affltn_Typ varchar2(20),
New_TaxID_sfx_Affltn_eff_Dt date,
New_TaxID_sfx_Affltn_Term_Dt date,
New_Affltn_Term_rsn_Cd varchar2(20),
Note varchar2(10)
);
insert into SRC_TGT_FILE_LOAD values('97941849 001','97941849 001','39694150','1831488519','DESAI','NEAL','A','MD','2701 N DECATUR RD','','11/01/2017', '12/31/9999',01,'','','DECATUR','GA',30033,'30033-5918','(404) 564-5400','Directory Phone','(404) 564-5403','Fax Phone Number','','','','Radiology, Interventional and Diagnostic', 'Radiology','Radiology, Diagnostic','Radiology, Interventional and Diagnostic','2701 N DECATUR RDDECATURGA30033','','HMO','HMO CAPPED OR FFS SPECIALISTS AND HOSPITALS','HMPA','Yes','188','N','FFS',0,'',0,0,'Accepting New Patients','Exclude','11/01/2017','12/31/9999','09/30/2020','Cancelled Contract','HMPA','10/01/2020','Yes',120,'FFS','','','','','Accepting New Patients','Exclude','SPEC1626','11/01/2017','12/31/9999','09/30/2020','Cancelled Contract','SPEC4505','10/01/2020','12/31/9999','581304565 014','27120272','1245206119','RADIOLOGY ASSOCIATES OF DEKALB','581304565 014','11/01/2017','12/31/9999','','','','','','','','','','EST -79982');
insert into SRC_TGT_FILE_LOAD values('97941849 001','97941849 001','39694150','1831488519','DESAI','NEAL','A','MD','2701 N DECATUR RD','','11/01/2017', '12/31/9999',01,'','','DECATUR','GA',30033,'30033-5918','(404) 564-5400','Directory Phone','(404) 564-5403','Fax Phone Number','','','','Radiology, Interventional and Diagnostic', 'Radiology','Radiology, Diagnostic','Radiology, Interventional and Diagnostic','2701 N DECATUR RDDECATURGA30033','','HIX','Exchanges SPC Hospital Ancillary ON Individual','HMX5','Yes','188','N','FFS',0,'',0,0,'Accepting New Patients','Exclude','11/01/2017','12/31/9999','09/30/2020','Cancelled Contract','HMX5','10/01/2020','Yes',120,'FFS','','','','','Accepting New Patients','Exclude','SPEC1626','11/01/2017','12/31/9999','09/30/2020','Cancelled Contract','SPEC4505','10/01/2020','12/31/9999','581304565 014','27120272','1245206119','RADIOLOGY ASSOCIATES OF DEKALB','581304565 014','11/01/2017','12/31/9999','','','','','','','','','','EST -79982'); -- date format seems wrong
insert into SRC_TGT_FILE_LOAD values('97941849 001','97941849 001','39694150','1831488519','DESAI','NEAL','A','MD','2701 N DECATUR RD','','11/01/2017','12/31/9999',01,'','','DECATUR','GA',30033,'30033-5918','(404) 564-5400','Directory Phone','(404) 564-5403','Fax Phone Number','','','','Radiology, Interventional and Diagnostic','Radiology','Radiology, Diagnostic','Radiology, Interventional and Diagnostic','2701 N DECATUR RDDECATURGA30033','','HIX','Exchanges SPC Hospital Ancillary ON Small Group','HMX5','Yes','188','N','FFS',0,'',0,0,'Accepting New Patients','Exclude','11/01/2017','12/31/9999','09/30/2020','Cancelled Contract','HMX6','10/01/2020','Yes',120,'FFS','','','','','Accepting New Patients','Exclude','SPEC1626','11/01/2017','12/31/9999','09/30/2020','Cancelled Contract','SPEC4505','10/01/2020','12/31/9999','581304565 014','27120272','1245206119','RADIOLOGY ASSOCIATES OF DEKALB','581304565 014','11/01/2017','12/31/9999','','','','','','','','','','EST -79982');
</code>
Target Tables
<code>
Insert into GRP1 (GRPID,GRPNM,GRPTYPE_CD,GRPEFCTV_DT,PAYE_ENTY_CD,PROV_DATA_OWNR_CD,DLGTD_CRDNTLG_ENTY_CD,HS_CPAY_IND,GRPROLE_CD,GRPTRMNTN_DT,GRPTRMNTN_RSN_CD,CREAT_DT,CREAT_USER_ID,LAST_UPDT_DT,LAST_UPDT_USER_ID,AUDT_UPDT_RSN_CD,AUDT_UPDT_RQST_ID) values (1486653,'TENET SC ISLAND MEDICAL LLC','8003',to_date('01-APR-02','DD-MON-RR'),'8000','PARIS',null,'N','1332',to_date('31-DEC-99','DD-MON-RR'),null,to_timestamp('12-APR-18 06.21.28.820000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'SPL',to_timestamp('07-FEB-20 06.02.35.574423000 AM','DD-MON-RR HH.MI.SSXFF AM'),'SPDS148802',null,null);
Insert into GRP1 (GRPID,GRPNM,GRPTYPE_CD,GRPEFCTV_DT,PAYE_ENTY_CD,PROV_DATA_OWNR_CD,DLGTD_CRDNTLG_ENTY_CD,HS_CPAY_IND,GRPROLE_CD,GRPTRMNTN_DT,GRPTRMNTN_RSN_CD,CREAT_DT,CREAT_USER_ID,LAST_UPDT_DT,LAST_UPDT_USER_ID,AUDT_UPDT_RSN_CD,AUDT_UPDT_RQST_ID) values (1331968,'CAROLINA HEALTH CENTERS INC','8003',to_date('01-APR-02','DD-MON-RR'),'8000','PARIS',null,'N','1332',to_date('31-DEC-99','DD-MON-RR'),null,to_timestamp('12-APR-18 06.21.28.994000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'SPL',to_timestamp('07-FEB-20 06.02.35.574423000 AM','DD-MON-RR HH.MI.SSXFF AM'),'SPDS148802',null,null);
Insert into GRP1 (GRPID,GRPNM,GRPTYPE_CD,GRPEFCTV_DT,PAYE_ENTY_CD,PROV_DATA_OWNR_CD,DLGTD_CRDNTLG_ENTY_CD,HS_CPAY_IND,GRPROLE_CD,GRPTRMNTN_DT,GRPTRMNTN_RSN_CD,CREAT_DT,CREAT_USER_ID,LAST_UPDT_DT,LAST_UPDT_USER_ID,AUDT_UPDT_RSN_CD,AUDT_UPDT_RQST_ID) values (1489056,'SCION DENTAL OF WEST VIRGINIA LLC','8019',to_date('01-APR-02','DD-MON-RR'),'8000','PARIS',null,'N','1332',to_date('31-DEC-99','DD-MON-RR'),null,to_timestamp('12-APR-18 06.21.28.838000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'SPL',to_timestamp('07-FEB-20 06.02.35.574423000 AM','DD-MON-RR HH.MI.SSXFF AM'),'SPDS148802',null,null);
Insert into ADDRESS (GRPADRS_KEY,GRPID,GRPLCTN_ID,GRPADRS_TYPE_CD,GRPADRS_EFCTV_DT,SPL_STNDRDZD_ADRS_ID,GRPADRS_TRMNTN_DT,GRPADRS_TRMNTN_RSN_CD,CREAT_DT,CREAT_USER_ID,LAST_UPDT_DT,LAST_UPDT_USER_ID,AUDT_UPDT_RSN_CD,AUDT_UPDT_RQST_ID) values (26,1331968,100,'8005',to_date('01-APR-02','DD-MON-RR'),33000,to_date('25-AUG-20','DD-MON-RR'),'8020',to_timestamp('12-APR-18 06.21.29.037000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'SPL',to_timestamp('25-AUG-20 08.08.30.735000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'AG49290',null,null);
Insert into ADDRESS (GRPADRS_KEY,GRPID,GRPLCTN_ID,GRPADRS_TYPE_CD,GRPADRS_EFCTV_DT,SPL_STNDRDZD_ADRS_ID,GRPADRS_TRMNTN_DT,GRPADRS_TRMNTN_RSN_CD,CREAT_DT,CREAT_USER_ID,LAST_UPDT_DT,LAST_UPDT_USER_ID,AUDT_UPDT_RSN_CD,AUDT_UPDT_RQST_ID) values (3,1331963,100,'8005',to_date('01-APR-02','DD-MON-RR'),2939,to_date('31-DEC-99','DD-MON-RR'),null,to_timestamp('12-APR-18 06.21.28.975000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'SPL',to_timestamp('13-AUG-20 11.39.08.186000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'MDX',null,null);
Insert into ADDRESS (GRPADRS_KEY,GRPID,GRPLCTN_ID,GRPADRS_TYPE_CD,GRPADRS_EFCTV_DT,SPL_STNDRDZD_ADRS_ID,GRPADRS_TRMNTN_DT,GRPADRS_TRMNTN_RSN_CD,CREAT_DT,CREAT_USER_ID,LAST_UPDT_DT,LAST_UPDT_USER_ID,AUDT_UPDT_RSN_CD,AUDT_UPDT_RQST_ID) values (12,1486653,100,'8005',to_date('01-APR-02','DD-MON-RR'),22089,to_date('31-DEC-99','DD-MON-RR'),null,to_timestamp('12-APR-18 06.21.28.992000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'SPL',to_timestamp('12-APR-18 06.21.28.996000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'SPL',null,null);
Insert into IDENTIFICATION (GRPALT_IDFCTN_KEY,GRPID,ALTID_SOR_CD,ALTID_TYPE_CD,GRPALTID_EFCTV_DT,ALTID_TXT,GRPALTID_TRMNTN_DT,GRPALTID_TRMNTN_RSN_CD,CREAT_DT,CREAT_USER_ID,LAST_UPDT_DT,LAST_UPDT_USER_ID,AUDT_UPDT_RSN_CD,AUDT_UPDT_RQST_ID) values (6,1439854,'8006','981',to_date('01-APR-02','DD-MON-RR'),'8X0000',to_date('31-DEC-99','DD-MON-RR'),null,to_timestamp('12-APR-18 06.21.29.502000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'SPL',to_timestamp('12-APR-18 06.21.29.502000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'SPL',null,null);
Insert into IDENTIFICATION (GRPALT_IDFCTN_KEY,GRPID,ALTID_SOR_CD,ALTID_TYPE_CD,GRPALTID_EFCTV_DT,ALTID_TXT,GRPALTID_TRMNTN_DT,GRPALTID_TRMNTN_RSN_CD,CREAT_DT,CREAT_USER_ID,LAST_UPDT_DT,LAST_UPDT_USER_ID,AUDT_UPDT_RSN_CD,AUDT_UPDT_RQST_ID) values (8,1439854,'8006','879',to_date('01-APR-02','DD-MON-RR'),'0001439854',to_date('31-DEC-99','DD-MON-RR'),null,to_timestamp('12-APR-18 06.21.29.511000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'SPL',to_timestamp('12-APR-18 06.21.29.511000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'SPL',null,null);
Insert into IDENTIFICATION (GRPALT_IDFCTN_KEY,GRPID,ALTID_SOR_CD,ALTID_TYPE_CD,GRPALTID_EFCTV_DT,ALTID_TXT,GRPALTID_TRMNTN_DT,GRPALTID_TRMNTN_RSN_CD,CREAT_DT,CREAT_USER_ID,LAST_UPDT_DT,LAST_UPDT_USER_ID,AUDT_UPDT_RSN_CD,AUDT_UPDT_RQST_ID) values (18,1439293,'8006','981',to_date('01-APR-02','DD-MON-RR'),'8ZT000',to_date('31-DEC-99','DD-MON-RR'),null,to_timestamp('12-APR-18 06.21.29.661000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'SPL',to_timestamp('12-APR-18 06.21.29.661000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'SPL',null,null);
Insert into CONTACT (GRPADRS_CNTCT_KEY,GRPADRS_KEY,CNTCT_DLVRY_MCHNSM_TYPE_CD,CNTCT_PUR_CD,GRPCNTCT_EFCTV_DT,CNTCT_SQNC_NBR,PRMRY_CNTCT_INFO_IND,CNTCT_VAL_TXT,CNTCT_PRSN_ROLE_TYPE_CD,CNTCT_PRSN_FRST_NM,CNTCT_PRSN_MID_NM,CNTCT_PRSN_LAST_NM,CNTCT_PRSN_TTL_CD,GRPCNTCT_TRMNTN_DT,GRPCNTCT_TRMNTN_RSN_CD,CREAT_DT,CREAT_USER_ID,LAST_UPDT_DT,LAST_UPDT_USER_ID,AUDT_UPDT_RSN_CD,AUDT_UPDT_RQST_ID) values (16,12,'162','162',to_date('01-APR-02','DD-MON-RR'),100,'N','8438561771',null,null,null,null,null,to_date('31-DEC-99','DD-MON-RR'),null,to_timestamp('12-APR-18 06.21.29.205000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'SPL',to_timestamp('14-FEB-20 06.38.54.538656000 AM','DD-MON-RR HH.MI.SSXFF AM'),'SPDS149654',null,null);
Insert into CONTACT (GRPADRS_CNTCT_KEY,GRPADRS_KEY,CNTCT_DLVRY_MCHNSM_TYPE_CD,CNTCT_PUR_CD,GRPCNTCT_EFCTV_DT,CNTCT_SQNC_NBR,PRMRY_CNTCT_INFO_IND,CNTCT_VAL_TXT,CNTCT_PRSN_ROLE_TYPE_CD,CNTCT_PRSN_FRST_NM,CNTCT_PRSN_MID_NM,CNTCT_PRSN_LAST_NM,CNTCT_PRSN_TTL_CD,GRPCNTCT_TRMNTN_DT,GRPCNTCT_TRMNTN_RSN_CD,CREAT_DT,CREAT_USER_ID,LAST_UPDT_DT,LAST_UPDT_USER_ID,AUDT_UPDT_RSN_CD,AUDT_UPDT_RQST_ID) values (38,26,'160','160',to_date('01-APR-02','DD-MON-RR'),100,'N','8643880648',null,null,null,null,null,to_date('31-DEC-99','DD-MON-RR'),null,to_timestamp('12-APR-18 06.21.29.231000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'SPL',to_timestamp('14-FEB-20 06.38.54.538656000 AM','DD-MON-RR HH.MI.SSXFF AM'),'SPDS149654',null,null);
Insert into CONTACT (GRPADRS_CNTCT_KEY,GRPADRS_KEY,CNTCT_DLVRY_MCHNSM_TYPE_CD,CNTCT_PUR_CD,GRPCNTCT_EFCTV_DT,CNTCT_SQNC_NBR,PRMRY_CNTCT_INFO_IND,CNTCT_VAL_TXT,CNTCT_PRSN_ROLE_TYPE_CD,CNTCT_PRSN_FRST_NM,CNTCT_PRSN_MID_NM,CNTCT_PRSN_LAST_NM,CNTCT_PRSN_TTL_CD,GRPCNTCT_TRMNTN_DT,GRPCNTCT_TRMNTN_RSN_CD,CREAT_DT,CREAT_USER_ID,LAST_UPDT_DT,LAST_UPDT_USER_ID,AUDT_UPDT_RSN_CD,AUDT_UPDT_RQST_ID) values (53,26,'162','162',to_date('01-APR-02','DD-MON-RR'),100,'N','8643880301',null,null,null,null,null,to_date('31-DEC-99','DD-MON-RR'),null,to_timestamp('12-APR-18 06.21.29.250000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'SPL',to_timestamp('14-FEB-20 06.38.54.538656000 AM','DD-MON-RR HH.MI.SSXFF AM'),'SPDS149654',null,null);
Insert into RELATIONSHIP (GRPGRPRLTNSHP_KEY,GRPID,RLTD_GRPID,GRPRLTNSHP_TYPE_CD,GRPRLTNSHP_EFCTV_DT,GRPRLTNSHP_TRMNTN_DT,GRPRLTNSHP_TRMNTN_RSN_CD,CREAT_DT,CREAT_USER_ID,LAST_UPDT_DT,LAST_UPDT_USER_ID,AUDT_UPDT_RSN_CD,AUDT_UPDT_RQST_ID) values (1,1332032,1489056,'8024',to_date('25-AUG-20','DD-MON-RR'),to_date('31-DEC-99','DD-MON-RR'),null,to_timestamp('25-AUG-20 03.11.55.554000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'AG49290',to_timestamp('25-AUG-20 03.11.55.554000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'AG49290',null,null);
Insert into RELATIONSHIP (GRPGRPRLTNSHP_KEY,GRPID,RLTD_GRPID,GRPRLTNSHP_TYPE_CD,GRPRLTNSHP_EFCTV_DT,GRPRLTNSHP_TRMNTN_DT,GRPRLTNSHP_TRMNTN_RSN_CD,CREAT_DT,CREAT_USER_ID,LAST_UPDT_DT,LAST_UPDT_USER_ID,AUDT_UPDT_RSN_CD,AUDT_UPDT_RQST_ID) values (4,1331968,1726233,'8024',to_date('25-AUG-20','DD-MON-RR'),to_date('25-AUG-20','DD-MON-RR'),'297',to_timestamp('25-AUG-20 06.43.01.228000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'AG49290',to_timestamp('25-AUG-20 07.37.03.631000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'AG49290',null,null);
Insert into SERVICE_TABLE (GRPNTWK_SRVC_TBL_KEY,GRPID,NTWK_KEY,SRVC_TBL_ID,GRPSRVC_TBL_EFCTV_DT,GRPRA_TYPE_CD,GRPSRVC_KEY_CD,GRPSRVC_TBL_TRMNTN_DT,GRPSRVC_TBL_TRMNTN_RSN_CD,CREAT_DT,CREAT_USER_ID,LAST_UPDT_DT,LAST_UPDT_USER_ID,AUDT_UPDT_RSN_CD,AUDT_UPDT_RQST_ID) values (53,1331930,1,'ASSB22009',to_date('01-APR-09','DD-MON-RR'),'SVC','A',to_date('31-DEC-99','DD-MON-RR'),null,to_timestamp('12-APR-18 06.21.30.012000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'SPL',to_timestamp('03-JUL-20 06.14.42.472521000 AM','DD-MON-RR HH.MI.SSXFF AM'),'SPDS154231',null,null);
Insert into SERVICE_TABLE (GRPNTWK_SRVC_TBL_KEY,GRPID,NTWK_KEY,SRVC_TBL_ID,GRPSRVC_TBL_EFCTV_DT,GRPRA_TYPE_CD,GRPSRVC_KEY_CD,GRPSRVC_TBL_TRMNTN_DT,GRPSRVC_TBL_TRMNTN_RSN_CD,CREAT_DT,CREAT_USER_ID,LAST_UPDT_DT,LAST_UPDT_USER_ID,AUDT_UPDT_RSN_CD,AUDT_UPDT_RQST_ID) values (55,1331930,1,'DGAHD2006',to_date('01-APR-09','DD-MON-RR'),'SVC','D',to_date('31-DEC-99','DD-MON-RR'),null,to_timestamp('12-APR-18 06.21.30.023000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'SPL',to_timestamp('03-JUL-20 06.14.42.472521000 AM','DD-MON-RR HH.MI.SSXFF AM'),'SPDS154231',null,null);
Insert into SERVICE_TABLE (GRPNTWK_SRVC_TBL_KEY,GRPID,NTWK_KEY,SRVC_TBL_ID,GRPSRVC_TBL_EFCTV_DT,GRPRA_TYPE_CD,GRPSRVC_KEY_CD,GRPSRVC_TBL_TRMNTN_DT,GRPSRVC_TBL_TRMNTN_RSN_CD,CREAT_DT,CREAT_USER_ID,LAST_UPDT_DT,LAST_UPDT_USER_ID,AUDT_UPDT_RSN_CD,AUDT_UPDT_RQST_ID) values (56,1331930,1,'ASSB12009',to_date('01-APR-09','DD-MON-RR'),'SVC','A',to_date('31-DEC-99','DD-MON-RR'),null,to_timestamp('12-APR-18 06.21.30.035000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'SPL',to_timestamp('03-JUL-20 06.14.42.472521000 AM','DD-MON-RR HH.MI.SSXFF AM'),'SPDS154231',null,null);
Insert into GRP_POA_NETWORK (GRPPOA_NTWK_KEY,GRPID,POA_NTWK_KEY,GRPPOA_NTWK_EFCTV_DT,MAX_MBR_CNT,GRPPOA_NTWK_TRMNTN_DT,GRPPOA_TERM_RSN_CD,CREAT_DT,CREAT_USER_ID,LAST_UPDT_DT,LAST_UPDT_USER_ID,AUDT_UPDT_RSN_CD,AUDT_UPDT_RQST_ID) values (2612,4000000001,248187,to_date('01-JAN-09','DD-MON-RR'),null,to_date('15-FEB-16','DD-MON-RR'),'303',to_timestamp('12-APR-18 06.22.00.213000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'SPL',to_timestamp('13-AUG-20 04.54.07.232000000 PM','DD-MON-RR HH.MI.SSXFF AM'),'MDX',null,null);
Insert into GRP_POA_NETWORK (GRPPOA_NTWK_KEY,GRPID,POA_NTWK_KEY,GRPPOA_NTWK_EFCTV_DT,MAX_MBR_CNT,GRPPOA_NTWK_TRMNTN_DT,GRPPOA_TERM_RSN_CD,CREAT_DT,CREAT_USER_ID,LAST_UPDT_DT,LAST_UPDT_USER_ID,AUDT_UPDT_RSN_CD,AUDT_UPDT_RQST_ID) values (2613,4000000001,313652,to_date('01-JAN-09','DD-MON-RR'),null,to_date('31-DEC-99','DD-MON-RR'),null,to_timestamp('12-APR-18 06.22.00.278000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'SPL',to_timestamp('13-AUG-20 04.54.06.957000000 PM','DD-MON-RR HH.MI.SSXFF AM'),'MDX',null,null);
Insert into GRP_POA_NETWORK (GRPPOA_NTWK_KEY,GRPID,POA_NTWK_KEY,GRPPOA_NTWK_EFCTV_DT,MAX_MBR_CNT,GRPPOA_NTWK_TRMNTN_DT,GRPPOA_TERM_RSN_CD,CREAT_DT,CREAT_USER_ID,LAST_UPDT_DT,LAST_UPDT_USER_ID,AUDT_UPDT_RSN_CD,AUDT_UPDT_RQST_ID) values (2614,4000000001,65761,to_date('01-JAN-09','DD-MON-RR'),null,to_date('31-DEC-99','DD-MON-RR'),null,to_timestamp('12-APR-18 06.22.00.344000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'SPL',to_timestamp('13-AUG-20 04.54.07.353000000 PM','DD-MON-RR HH.MI.SSXFF AM'),'MDX',null,null);
Insert into POA_CONTACT (POA_CNTCT_KEY,POA_KEY,CNTCT_DLVRY_MCHNSM_TYPE_CD,CNTCT_PUR_CD,POA_CNTCT_EFCTV_DT,CNTCT_SQNC_NBR,DIR_DSPLY_IND,PRMRY_CNTCT_INFO_IND,CNFDNTL_CNTCT_IND,CNTCT_VAL_TXT,CNTCT_PRSN_ROLE_TYPE_CD,CNTCT_PRSN_FRST_NM,CNTCT_PRSN_MID_NM,CNTCT_PRSN_LAST_NM,CNTCT_PRSN_TTL_CD,POA_CNTCT_TRMNTN_DT,POA_CNTCT_TRMNTN_RSN_CD,CREAT_DT,CREAT_USER_ID,LAST_UPDT_DT,LAST_UPDT_USER_ID,AUDT_UPDT_RSN_CD,AUDT_UPDT_RQST_ID) values (39,1000000013,'160','160',to_date('01-APR-02','DD-MON-RR'),100,'N','N','N','8437923697',null,null,null,null,null,to_date('31-DEC-99','DD-MON-RR'),null,to_timestamp('12-APR-18 04.43.34.722000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'SPL',to_timestamp('07-FEB-20 06.04.16.458524000 AM','DD-MON-RR HH.MI.SSXFF AM'),'SPDS148809',null,null);
Insert into POA_CONTACT (POA_CNTCT_KEY,POA_KEY,CNTCT_DLVRY_MCHNSM_TYPE_CD,CNTCT_PUR_CD,POA_CNTCT_EFCTV_DT,CNTCT_SQNC_NBR,DIR_DSPLY_IND,PRMRY_CNTCT_INFO_IND,CNFDNTL_CNTCT_IND,CNTCT_VAL_TXT,CNTCT_PRSN_ROLE_TYPE_CD,CNTCT_PRSN_FRST_NM,CNTCT_PRSN_MID_NM,CNTCT_PRSN_LAST_NM,CNTCT_PRSN_TTL_CD,POA_CNTCT_TRMNTN_DT,POA_CNTCT_TRMNTN_RSN_CD,CREAT_DT,CREAT_USER_ID,LAST_UPDT_DT,LAST_UPDT_USER_ID,AUDT_UPDT_RSN_CD,AUDT_UPDT_RQST_ID) values (40,1000000013,'162','157',to_date('01-APR-02','DD-MON-RR'),101,'N','N','N','8437922046',null,null,null,null,null,to_date('31-DEC-99','DD-MON-RR'),null,to_timestamp('12-APR-18 04.43.34.732000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'SPL',to_timestamp('07-FEB-20 06.04.16.458524000 AM','DD-MON-RR HH.MI.SSXFF AM'),'SPDS148809',null,null);
Insert into POA_CONTACT (POA_CNTCT_KEY,POA_KEY,CNTCT_DLVRY_MCHNSM_TYPE_CD,CNTCT_PUR_CD,POA_CNTCT_EFCTV_DT,CNTCT_SQNC_NBR,DIR_DSPLY_IND,PRMRY_CNTCT_INFO_IND,CNFDNTL_CNTCT_IND,CNTCT_VAL_TXT,CNTCT_PRSN_ROLE_TYPE_CD,CNTCT_PRSN_FRST_NM,CNTCT_PRSN_MID_NM,CNTCT_PRSN_LAST_NM,CNTCT_PRSN_TTL_CD,POA_CNTCT_TRMNTN_DT,POA_CNTCT_TRMNTN_RSN_CD,CREAT_DT,CREAT_USER_ID,LAST_UPDT_DT,LAST_UPDT_USER_ID,AUDT_UPDT_RSN_CD,AUDT_UPDT_RQST_ID) values (41,1000000013,'162','162',to_date('01-APR-02','DD-MON-RR'),102,'N','N','N','8437922046',null,null,null,null,null,to_date('31-DEC-99','DD-MON-RR'),null,to_timestamp('12-APR-18 04.43.34.748000000 AM','DD-MON-RR HH.MI.SSXFF AM'),'SPL',to_timestamp('07-FEB-20 06.04.16.458524000 AM','DD-MON-RR HH.MI.SSXFF AM'),'SPDS148809',null,null);
</code>
Thanks
Vasu

Comments
Post Details
Added on Dec 2 2020
7 comments
399 views