create or replace trigger TRGADDmisunsismst
after insert on misunsismst
FOR EACH ROW
declare
i int;--rmintdatmst0的总列数
j int;--misunsismst的总列数
k int;--misunsismst表包含各项的明细数
m int;
n int;
p int;
loopcount int;
column_id int;--rmintdatmst0表最后一列的id
new_column varchar2(200);--rmintdatmst0表欲增加的列名
column_name varchar2(200);
type columnset is record(name varchar2(100));
type coltab is table of columnset index by binary_integer;
srtab coltab;
mycoltab coltab;
insertsql varchar2(200);
fromsql varchar2(200);
begin
select count(*) into i from user_tab_columns where table_name='RMINTDATMST0';
select count(*) into j from user_tab_columns where table_name='MISUNSISMST';
select count(*) into k from user_tab_columns where table_name='