Skip to Main Content

Require Solution

AzamshareefSep 23 2013 — edited Sep 24 2013

Dear All,

I have problem in user define trigger code.

I have 2 tables name A and B

Table A

name varchar2(1000)

Table B

old_name varchar2(1000)

new_name varchar2(1000)

update_date date

I want to record new and old values for table A in Table B.

Suppose for Table A, name is updated from xxx to yyy then i want to insert these values in table B like this

xxx    yyy      23-SEP-2013

How do i do that please help me with a sample code.

Thanks in Advance.

Post Details
Added on Sep 23 2013