Create trigger

From: Robert Brown <rob_99_at_my-deja.com>
Date: Sat, 19 Jun 1999 15:34:34 GMT
Message-ID: <7kgdaa$sre$1@nnrp1.deja.com>

Hi,

Sybase user here. Just hoping someone can translate some syntax for me. In Sybase you can create a trigger with the following syntax:

create trigger trigger_name
on source_table
for insert as
begin
insert into destination_table
select * from inserted
end
go

Could somebody please advise the equivalent syntax for Oracle. Assume source_table and destination_table have the same layout, consisting of many columns of mixed types.

Any help most appreciated.

Rob

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sat Jun 19 1999 - 10:34:34 CDT