请问这个循环如何做.谢谢各位
create table test(
aaa number,
bbb char(10),
ccc varchar2(10),
ddd varchar2(10),
eee varchar2(10),
fff varchar2(10)
)
begin
if updating( 'aaa ') then
insert into BBB values(1, 'aaa ',:NEW.aaa);
elsif updating( 'bbb ') then
insert into BBB values(2, 'bbb ',:NEW.aaa);
elsif updating( 'ccc ') then
insert into BBB values(3, 'ccc ',:NEW.aaa);
elsif updating( 'ddd ') then
insert into BBB values(4, 'ddd ',:NEW.aaa);
elsif updating( 'eee ') then
insert into BBB values(5, 'eee ',:NEW.aaa);
elsif updating( 'fff ') then
insert into BBB values(6, 'fff ',:NEW.aaa);