OraFAQ Forum: SQL & PL/SQL » How to create triggers

Home » SQL & PL/SQL » SQL & PL/SQL » How to create triggers

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to create triggers [message #237617]

Tue, 15 May 2007 04:11

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.

Report message to a moderator

Re: How to create triggers [message #237618 is a reply to message #237617]

Tue, 15 May 2007 04:14

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

"Application Developer's Guide - Fundamentals", Chapter 9 "Coding Triggers"

Regards
Michel

Report message to a moderator

Re: How to create triggers [message #237620 is a reply to message #237618]

Tue, 15 May 2007 04:20

mailtokkalyan
Messages: 65
Registered: December 2006
Location: Bangalore

Member

Thank you very much

Report message to a moderator

Previous Topic:	Get the Recent Record (Merged)
Next Topic:	like clause

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 21:08:08 CDT 2024