exp cjtxx/123456@192.168.80.231/orcl file=d:\cjtxx.dmp owner=cjtxx [tables=tablename] imp cjttest/123456@192.168.80.231/orcl file=d:\cjtxx.dmp full=y insert into bdf2_user_position(id_,position_id_,username_) values(:new.username_,'ptjs',:new.username_);
触发器根据新插入的表记录,新增另一条表信息
create or replace trigger test
after insert on bdf2_user
for each row
declare
-- local variables here
begin
insert into bdf2_user_position(id_,position_id_,username_) values(:new.username_,'ptjs',:new.username_);
end test;