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!
Previous Topic: selecting potentially duplicate values
Next Topic: adding colums, database becomes slow
Goto Forum:
  


Current Time: Sun Dec 22 20:00:24 CST 2024