Home » Other » General » Can anyone solve my Problem with Trigger.
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?
Previous Topic: MS Access Drawbacks compared to Oracle.
Next Topic: Oracle11i
Goto Forum:
  


Current Time: Thu Mar 28 19:47:43 CDT 2024