Home » SQL & PL/SQL » SQL & PL/SQL » How to create triggers
icon2.gif  How to create triggers [message #237617] Tue, 15 May 2007 04:11 Go to next message
mailtokkalyan
Messages: 65
Registered: December 2006
Location: Bangalore
Member

Hi all,
I have two tables like employees and employees_history.
I want copy the updated or deleted rows in employees table, that rows should copied into employees_history table.
for that, how to create a trigger...?

Please tell me.

Employees
empno ename salary
101 KKS 10000
102 RMK 15000

if i update or deleted in this table, that particular row should insert into employee_history table.

Re: How to create triggers [message #237618 is a reply to message #237617] Tue, 15 May 2007 04:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"Application Developer's Guide - Fundamentals", Chapter 9 "Coding Triggers"

Regards
Michel
Re: How to create triggers [message #237620 is a reply to message #237618] Tue, 15 May 2007 04:20 Go to previous message
mailtokkalyan
Messages: 65
Registered: December 2006
Location: Bangalore
Member

Thank you very much
Previous Topic: Get the Recent Record (Merged)
Next Topic: like clause
Goto Forum:
  


Current Time: Tue Dec 06 04:43:33 CST 2016

Total time taken to generate the page: 0.15487 seconds