写一条触发器完成以下作业:
创建上述表的备份表,命名为re_st,并增加对应字段修改时间(UD),在执行更新操作(st)表时,先把该数据备份到其对应的re_st表中。create or replace trigger tigger_st
before update on st
for each row
begin
declare @sno number
declare @sn char(20)
declare @sd char(20)
declare @sa number
select @sno = sno,@sn = sn,@sd = sd,@sa = sa inserted
insert into re_st(sno,sn,sd,sa,d) values(@sno,@sn,@sd,@sa,:new.t_date)
end tigger_st;错哪了?触发器
创建上述表的备份表,命名为re_st,并增加对应字段修改时间(UD),在执行更新操作(st)表时,先把该数据备份到其对应的re_st表中。create or replace trigger tigger_st
before update on st
for each row
begin
declare @sno number
declare @sn char(20)
declare @sd char(20)
declare @sa number
select @sno = sno,@sn = sn,@sd = sd,@sa = sa inserted
insert into re_st(sno,sn,sd,sa,d) values(@sno,@sn,@sd,@sa,:new.t_date)
end tigger_st;错哪了?触发器
解决方案 »
- 求助双机热备下监听程序注册的问题
- oracle 可有像SQLSERVER的#临时表功能的方法
- 急!用recover database until time恢复数据库出错
- 谁来帮我看看用C++封装的SQL语句啊?
- clob 问题:表结构如下,如何插入4000以上字符的记录?在线等候
- 关于oracle9I建立表空间,出现ORA-01144: 文件大小 (5242880 块) 超出 4194303 块的最大数的错误
- Oracle 8.05 如何与SQL Server相连?
- ORACLE 数据恢复问题
- 怎么查看当前oracle服务器事务的多少
- ORA-01417 : 表可以外部连接到至多一个其他的表?
- otlv4访问多种数据库方案
- ORA-12514: TNS:listener does not currently know of service requested in connect
sno number;
sn char(20);
sd char(20);
sa number;
----
select (sno,sn,sd,sa) into (sno,sn,sd,sa) inserted
insert into re_st(sno,sn,sd,sa,d) values(sno,sn,sd,sa,:new.t_date)
after update on st
for each row
declare
@sno number
@sn char(20)
@sd char(20)
@sa number
-----
begin select @sno = sno,@sn = sn,@sd = sd,@sa = sa inserted
insert into re_st(sno,sn,sd,sa,d) values(@sno,@sn,@sd,@sa,:new.t_date)
end tigger_st;还是不行啊
after update on st
for each row
declare
sno number;
sn char(20);
sd char(20);
sa number;
-----
begin select (sno,sn,sd,sa) into (sno,sn,sd,sa) inserted
insert into re_st(sno,sn,sd,sa,d) values(sno,sn,sd,sa,:new.t_date)
end tigger_st; 错误PLS-00103