ORACLE触发器，创建后提示创建成功，编译错误

逻辑：如果tc_ggm_file插入数据，则tc_gge_file,复制最大版本号的数据到新版本上，版本号新旧都是通过tc_ggm_file 获取

create or replace trigger fr_cs

before INSERT

on tc_ggm_file

for each row

begin

INSERT INTO tc_gge_file (tc_gge01,tc_gge02,tc_gge03,tc_gge04,tc_gge05,tc_gge06,tc_gge07)

select tc_gge01,tc_gge02,tc_gge03,tc_gge04,tc_gge05,tc_gge06,:new.tc_ggm01 from tc_gge_file

where tc_gge01 :=:new.tc_gge01 and

tc_gge07 :=:new.tc_gge07;

end;

FineReport 起床了 发布于 2022-9-5 11:48 （编辑于 2022-9-5 11:51）

回答问题关注问题

悬赏：3 F币 + 添加悬赏

提示：增加悬赏、完善问题、追问等操作，可使您的问题被置顶，并向所有关注者发送通知

共2回答

最佳回答

起床了Lv4见习互助
发布于2022-9-19 09:36

CREATE

OR REPLACE TRIGGER tr_fr_ggf before INSERT ON tc_ggm_file FOR each ROW

BEGIN

INSERT INTO tc_ggf_file ( tc_ggf01, tc_ggf02, tc_ggf03, tc_ggf04, tc_ggf05, tc_ggf06, tc_ggf07, tc_ggf08,tc_ggf09,tc_ggf10,tc_ggf14 )

SELECT

tc_ggf01, tc_ggf02, tc_ggf03, tc_ggf04, tc_ggf05, tc_ggf06, tc_ggf07, tc_ggf08,tc_ggf09,

:new.tc_ggm02 AS tc_ggf10 ,tc_ggf14

FROM

tc_ggf_file

WHERE

tc_ggf14 =:new.tc_ggm00

AND tc_ggf10 =:new.tc_ggm01;

END;

weibwLv7高级互助
发布于2022-9-13 19:20

应该是少了括号

0关注人数

273浏览人数

最后回答于：2022-9-19 09:36

活动推荐更多

热门课程更多

确定取消