| Garlapati |
Posted: Mar 07, 2008 07:40:56 AM |
Total Post: 30
Joined: Apr, 2007
|
Hi,
I have to updated table through the procedure
i want to generate log file which includes
1) what are the records are updated
list of updated records only |
|
|
 Nehru |
| Posted: Mar 10, 2008 02:06:02 AM |  |
|
Total Post: 46
Joined: Jul, 2007
|
Hi,
Better to Use Triggers..
Track the all Column of the table to know the which column has been updated, through Triggers.
Thanks,
Nehru
|
|
|
|
|
| pammi |
| Posted: Mar 11, 2008 12:15:06 AM | |
|
Total Post: 21
Joined: Feb, 2008
|
ya u could use a after row trigger
create or replace trigger trig after update on emp
for each row
begin
insert into log_table(:new.empno,:new.sal);
end;
|
|
|
|
|
| Vish |
| Posted: Jul 28, 2008 01:05:56 AM | |
|
Total Post: 89
Joined: Jan, 2007
|
you can use after row update trigger.
Put old value in one table call history table along with user name and system date from that u can creat report or log file
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
