Re: triggers

From: Derek <d.rogers_at_its.uq.edu.au>
Date: Tue, 6 Jan 2004 14:31:47 +1000
Message-ID: <btddiv$f6v$1@bunyip.cc.uq.edu.au>

do the gathering of data from the other table inside the trigger body ..

CREATE OR REPLACE TRIGGER trigger_name
AFTER UPDATE ON updated_table
FOR EACH ROW
BEGIN
SELECT fields INTO variables FROM other_table ...

END; Cheers,
Derek

"Choung" <cchao_at_pmc.ca> wrote in message news:yEeKb.198876$PD3.5916031_at_nnrp1.uunet.ca...
> Hi,
>
> I need to create a trigger that requires input from more than one table,
is
> this possible? I want the trigger to be activated when one table gets
> updated. The other table may not change, I just want information from it.
>
> thanks,
>
>
Received on Mon Jan 05 2004 - 22:31:47 CST