oracle触发器与数据导入导出的简单使用

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;

  

上一篇:debian安装dwm窗口管理器


下一篇:[收藏转贴]struct探索·extern "C"含义探索 ·C++与C的混合编程·C 语言高效编程的几招