Home » SQL & PL/SQL » SQL & PL/SQL » trigger to update different database
trigger to update different database [message #6708] Fri, 02 May 2003 07:05 Go to next message
S
Messages: 27
Registered: December 2001
Junior Member
Can I write a trigger on a table which will update another table in a different database?

Report message to a moderator

Re: trigger to update different database [message #6723 is a reply to message #6708] Fri, 02 May 2003 11:48 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Yes - you would need a database link pointing to the other instance.

Report message to a moderator

Previous Topic: How to I convert this UPDATE statement from MSSQL to Oracle?
Next Topic: multi column subqueries
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 09:55:04 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.