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.