写一条触发器完成以下作业:
创建上述表的备份表,命名为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;错哪了?触发器
解决方案 »
- 语句转换
- 刚学习plsql,请问一下,游标是不是只查询数据用?复合数据类型中索引表,嵌套表,数组分别适用于什么场合?求大虾帮忙解决这两个问题!!
- oracle 导入数据的问题~~~~~~~~~
- 讨论:分组查询的问题
- 如何将数据从USER1复制到?USER2?
- oracle数据绑定
- oracle 日志分类和用途
- 请问如何找到Oracle数据库中某表某字段包含特定值的某个记录?
- *.dbf文件和*.ora文件的区别
- 按你们的经验1000个数据更新的最短时间!
- 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