OraFAQ Forum: Server Administration » How to use Trigger move record from one table to another table?

Home » RDBMS Server » Server Administration » How to use Trigger move record from one table to another table?

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

How to use Trigger move record from one table to another table? [message #374129]

Sat, 26 May 2001 19:39

Mon
Messages: 7
Registered: May 2001

Junior Member

I want trigger example to move record from one table to another table by check from specific field
example

table ALLUSER have field (ID,NAME,SURNAME,STATUS)
when I update field STATUS to "D" it mean user dead
trigger will remove that record from table ALLUSER and insert into table DEADUSER
and when I update STATUS to "I" it mean user inactive
trigger will remove that record from table ALLUSER and insert into table INACTIVEUSER

Thanks

Report message to a moderator

Previous Topic:	Export / Import of a table
Next Topic:	How to use Trigger move record from one table to another table?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 17:32:13 CDT 2024