开发者

row level Trigger code

开发者 https://www.devze.com 2023-02-28 00:28 出处:网络
HI I have a table A and Table B I need to write tri开发者_开发问答gger on table A for each row insert on table A same row should get inserted in Table B

HI

I have a table A and Table B I need to write tri开发者_开发问答gger on table A for each row insert on table A same row should get inserted in Table B Table A and Table B have same structure.

Please help me with code

Thanks Xyz,


You can check the documentation: http://docs.oracle.com/cd/E11882_01/server.112/e25789/srvrside.htm#i13313

You have to write something like:

create or replace trigger replicate
after insert on A
for each row
.
.
.
0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号