create table t( col_1 varchar2(5 char), col_2 varchar2(5 char)) / create table tt( t_col varchar2(5 char)) / SQL> create or replace trigger tri_select 2 after insert on t 3 for each row 4 begin 5 insert into tt(t_col) 6 values(:new.col_1); 7 end tri_select; 8 /
create table t(
col_1 varchar2(5 char),
col_2 varchar2(5 char))
/
create table tt(
t_col varchar2(5 char))
/
SQL> create or replace trigger tri_select
2 after insert on t
3 for each row
4 begin
5 insert into tt(t_col)
6 values(:new.col_1);
7 end tri_select;
8 /
Trigger created
SQL> insert into t values('aaa','000');
1 row inserted
SQL> select * from t;
COL_1 COL_2
---------- ----------
aaa 000
SQL> select * from tt;
T_COL
----------
aaa
SQL> insert into t values('CSDN','0001');
1 row inserted
SQL> select * from tt;
T_COL
----------
aaa
CSDN
SQL>
初学者,不要笑我哈 ,呵呵O(∩_∩)O~
after insert on t 这里怎么添? col_1='wxl'
create or replace trigger tri_select
before insert on t--插入后
create or replace trigger tri_select
after insert on t
insert into a values (...) returning col1 into strcol1;--strcol1 自己定义下
sql基本语法 里好像没有这个的。