Trigger Problem

sanjeev.thummala · #1 (**permalink**) 07-01-2009

Hi all, iam created two tables names like t1 and t2.the follwoing structures are like this t1->create table t1(id int ,name varchar2(50),status int) t2->create table t2(id int ,name varchar2(50),status int) when status changed in t1 (if status=1 then) table it will delete that row and insert into t2 table so, i created one trigger like this but it is not excuted it's giving complie errors,please help me out create or replace trigger updatetrigger after update of status on t1 for each row declare cursor c_t1 is select * from t1 where status!=0; begin delete from t1 where status!=0; for eachtrigger1 in c_t1 loop insert into t2 values(eachtrigger1.id,eachtrigger1.name,eachtrigger1.status) end loop; end updatetrigger;

ecearund · #2 (**permalink**) 07-01-2009

@sanjeev,

Dear, U have missed out the semi-colon at the end of insert statement,
thats why some error may occur.

Just execute the following stuff

Code:

create or replace trigger update_trigger 
after update of status on t1 
for each row 

declare 
cursor c_t1 is 
select * from t1 where status!=0; 
begin 
delete from t1 where status!=0; 
for eachtrigger1 in c_t1 loop 
insert into t2 values(eachtrigger1.id,eachtrigger1.name,eachtrigger1.status);
end loop; 
end update_trigger;

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Logical Mechanism of Trigger / How DB thinks about Trigger	tvgiriprasad	Oracle	4	06-04-2009 03:30 AM
trigger	Thirumurugan.K	Oracle	4	11-27-2008 07:30 AM
what is a trigger?	srinu.tenali	SQL Server	11	11-10-2008 12:57 AM
Trigger	goodstudent	SQL	2	03-14-2008 06:03 AM
what is trigger	amaravadi11	SQL	8	01-23-2008 03:10 PM

Trigger Problem

Trigger Problem

Similar Threads