| Can anyone solve my Problem with Trigger. [message #103288] |
Tue, 29 April 2003 23:54 |
Sheshadri
Messages: 12
Registered: June 2002
|
Junior Member |
|
|
Hi,
I have created a table called emp with
create table emp
(empno number(2),ename varchar210),job varchar2(10));
I have inserted some records into it.
And I have another table called empaud created with
Create table empaud
(fld_name varchar2(10),old varchar2(10),
new varchar2(10));
Now I have to write a trigger which will fire while modifying any of the columns of emp table and should Insert the Modified Col Name,Old value and New value to another table empaud.
Can anyone help me?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
