create table tmp_test (src_table,src_table_col,trg_table,trg_table_col);insert into tmp_teat values('TAB_A' ,'COL_1','TAB_R','COL_3');
insert into tmp_teat values('TAB_A' ,'COL_2','TAB_R','COL_4');
insert into tmp_teat values('TAB_A' ,'COL_3','TAB_Z','COL_1');
insert into tmp_teat values('TAB_B' ,'COL_1','TAB_Z','COL_2');
insert into tmp_teat values('TAB_B' ,'COL_4','TAB_Z','COL_3');
insert into tmp_teat values('TAB_C' ,'COL_4','TAB_X','COL_1');
insert into tmp_teat values('TAB_C' ,'COL_2','TAB_X','COL_2');
COMMIT;我想写一个存储过程P_TEST,将结果存放都tmp_result表中,
BEGIN
P_TEST;
END;得到的结果:select * from tmp_result order by 1 为:
'TAB_A' 'COL_1,COL_2' 'TAB_R' 'COL_3,COL_4'
'TAB_A' 'COL_3' 'TAB_Z' 'COL_1'
'TAB_B' 'COL_1,COL_4' 'TAB_Z' 'COL_2,COL_3'
'TAB_C' 'COL_2,COL_4' 'TAB_X' 'COL_1,COL_2'
存储过程
insert into tmp_teat values('TAB_A' ,'COL_2','TAB_R','COL_4');
insert into tmp_teat values('TAB_A' ,'COL_3','TAB_Z','COL_1');
insert into tmp_teat values('TAB_B' ,'COL_1','TAB_Z','COL_2');
insert into tmp_teat values('TAB_B' ,'COL_4','TAB_Z','COL_3');
insert into tmp_teat values('TAB_C' ,'COL_4','TAB_X','COL_1');
insert into tmp_teat values('TAB_C' ,'COL_2','TAB_X','COL_2');
COMMIT;我想写一个存储过程P_TEST,将结果存放都tmp_result表中,
BEGIN
P_TEST;
END;得到的结果:select * from tmp_result order by 1 为:
'TAB_A' 'COL_1,COL_2' 'TAB_R' 'COL_3,COL_4'
'TAB_A' 'COL_3' 'TAB_Z' 'COL_1'
'TAB_B' 'COL_1,COL_4' 'TAB_Z' 'COL_2,COL_3'
'TAB_C' 'COL_2,COL_4' 'TAB_X' 'COL_1,COL_2'
存储过程
从tmp_test 取出结果到tmp_result表中
select src_table,wm_concat(src_table_col),trg_table,wm_concat(trg_table_col) from
tmp_test group by src_table,trg_table
从tmp_test 取出结果到tmp_result表中
直接create table tmp_result as select * from tmp_test;