Home » RDBMS Server » Server Administration » Re: What's wrong with the insert statement in a trigger?
Re: What's wrong with the insert statement in a trigger? [message #370072] Sun, 10 December 2000 04:12
yushuai
Messages: 5
Registered: December 2000
Junior Member
change the follow code
(select 1
into var_num
from t_2
where t_2.id = :new.id;)
as
select count(*)
into var_num
where exist(select 1 from t_2 where t_2.id = :new.id);
It's ok!

Report message to a moderator

Previous Topic: selecting potentially duplicate values
Next Topic: adding colums, database becomes slow
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 02 01:37:29 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.