Dear Experts,
Please help me to insert data in temp table
CREATE TABLE TLT
(
CHNL_NAME VARCHAR2(20 BYTE),
RSDS_DESC VARCHAR2(200 BYTE),
R_BIN VARCHAR2(20 BYTE),
B_BIN VARCHAR2(20 BYTE)
);
INSERT INTO TLT VALUES('DVC','SUCESS','111','202');
INSERT INTO TLT VALUES('DVC','FAILURE','111','112');
INSERT INTO TLT VALUES('DVC','PENDING','111','203');
INSERT INTO TLT VALUES('DVC','FAILURE','112','114');
CREATE TABLE MB_HOST
(
BIN VARCHAR2(20 BYTE)
);
Insert into MB_HOST (BIN) values ('111');
Insert into MB_HOST (BIN) values ('112');
Insert into MB_HOST (BIN) values ('113');
Insert into MB_HOST (BIN) values ('114');
INSERT INTO TLT VALUES('DVC','SUCESS','112','111');
INSERT INTO TLT VALUES('DVC','PENDING','112','204');
CREATE TABLE TEMP_TB
(
T_CHNL_NAME VARCHAR2(20 BYTE),
T_RSDS_DESC VARCHAR2(200 BYTE),
T_R_BIN VARCHAR2(20 BYTE),
T_B_BIN VARCHAR2(20 BYTE)
);
I want to truncate and insert data in temp table based on mb_host by using loop.
Expected data in temp table
Required Result
T_CHNL_NAME T_RSDS_DESC T_R_BIN T_B_BIN
DVC SUCESS 111 202
DVC FAILURE 111 112
DVC PENDING 111 203
DVC FAILURE 112 114
DVC SUCESS 112 111
DVC PENDING 112 204
pLEASE HELP