create triger tr_u1

after update on tbwb_board_a01(adminnotice_yn)

execute update tbwb_board_a01_content set adminnotice_yn = obj.adminnotice_yn where uno = obj.uno

create triger tr_u2

after update on tbwb_board_a01(del_yn)

execute update tbwb_board_a01_content set del_yn = obj.del_yn where uno = obj.uno

><Class Name>

>

>     tbwb_board_a01_content

>

> <Attributes>

>

>     uno                  NUMERIC(15,0)

>     content              CHARACTER VARYING(1073741823)

>     adminnotice_yn       CHARACTER(1) DEFAULT \'N\'

>     del_yn               CHARACTER(1) DEFAULT \'N\'

>

> <Constraints>

>

>     UNIQUE u_tbwb_board_a01_content_uno ON tbwb_board_a01_content (uno)

>     INDEX idx1 ON tbwb_board_a01_content (adminnotice_yn,del_yn,uno)

아래와 같이 trigger 를 작성하여 tbwb_board_a01 에서 수정이 발생할 경우 tbwb_board_a01_content 에 그 내용이 반영되도록 하시면 됩니다. 신경쓰실점은 해당 필드가 변경될때만 trigger 가 수행되도록 하시면 됩니다.

create triger tr_u1

after update on tbwb_board_a01(adminnotice_yn)

execute update tbwb_board_a01_content set adminnotice_yn = obj.adminnotice_yn where uno = obj.uno

create triger tr_u2

after update on tbwb_board_a01(del_yn)

execute update tbwb_board_a01_content set del_yn = obj.del_yn where uno = obj.uno

><Class Name>

>

>     tbwb_board_a01_content

>

> <Attributes>

>

>     uno                  NUMERIC(15,0)

>     content              CHARACTER VARYING(1073741823)

>     adminnotice_yn       CHARACTER(1) DEFAULT \'N\'

>     del_yn               CHARACTER(1) DEFAULT \'N\'

>

> <Constraints>

>

>     UNIQUE u_tbwb_board_a01_content_uno ON tbwb_board_a01_content (uno)

>     INDEX idx1 ON tbwb_board_a01_content (adminnotice_yn,del_yn,uno)