Dear Experts
12.1.0.2.0
create TABLE TEMP
(
AGENTID VARCHAR2(20),
AGENTMODE VARCHAR(100)
);
INSERT INTO TEMP VALUES (1234,'Direct|Indirect|Left|Right');
insert into temp values (8574,'Direct|Left');
create table mode_cnfg
(
MODE_NAME VARCHAR2(20),
MODE_NUM VARCHAR2(20)
);
INSERT INTO MODE_CNFG VALUES('Direct',21);
INSERT INTO MODE_CNFG VALUES('Indirect',22);
INSERT INTO MODE_CNFG VALUES('Left',38);
insert into mode_cnfg values('Right',75);
Here i want to insert record in main table from temp table by joining mode_cnfg table
create TABLE main_tb
(
M_AGENTID VARCHAR2(20),
M_AGENTMODE VARCHAR(100)
);
Desired result from
select * from main_tb;
Please help