Re: begin .. for each row in other table{ } ... end
something like
create trigger tester
after insert on client
for each row
BEGIN
@id= select s.sid from salesman s;
INSERT
INTO clientUsers
values(@id,new.cid,'I');
END
this doesn't work->error
Edited 1 time(s). Last edit at 04/01/2006 12:09PM by davy timmermans.
Subject
Views
Written By
Posted
4138
March 30, 2006 04:40PM
2530
March 30, 2006 05:08PM
2348
April 01, 2006 06:54AM
2327
April 01, 2006 10:20AM
Re: begin .. for each row in other table{ } ... end
2396
April 01, 2006 11:52AM
1966
April 02, 2006 11:52AM
6663
April 03, 2006 08:40AM
2248
April 03, 2006 12:25PM
2219
April 04, 2006 08:06AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.