Simple use of Oracle triggers and data import Export

Exp cjtxx/[email PROTECTED]/ORCL file=d:\cjtxx.dmp owner=cjtxx [tables=tablename]imp cjttest/[email PROTECTED]/ORCL File=d:\cjtxx.dmp full=y INSERT INTO bdf2_user_position (id_,position_id_,username_) VALUES (: New.username_, ' Ptjs ',: NEW.USERNAME_);

Trigger adds another table message based on the newly inserted table record

Create or replace trigger test after insert on Bdf2_user for each    rowdeclare  --Local variables Herebegin  Insert into bdf2_user_position (id_,position_id_,username_) VALUES (: New.username_, ' Ptjs ',: new.username_); end test;

　　

Simple use of Oracle triggers and data import Export