Home » SQL & PL/SQL » SQL & PL/SQL » Trigger problem
Trigger problem [message #234761] Thu, 03 May 2007 02:20 Go to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member

Here is two tables: -

Table A cols
Message
location
city

Table B cols
Message
location
city

I want to create a trigger, so that when any matching message column "HELLO" comes to table A, it gets to table B and get deleted from table A.
Pls reply..

Arun
Re: Trigger problem [message #234777 is a reply to message #234761] Thu, 03 May 2007 02:36 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It can be Wink
drop table a;
rename b to a;

Or is "HELLO" a keyword to move message from a to b and only in this case?

Regards
Michel
Previous Topic: max count top 4
Next Topic: create a trigger execute in particular date.
Goto Forum:
  


Current Time: Sun Dec 11 02:36:11 CST 2016

Total time taken to generate the page: 0.10740 seconds