UPDATE over a db_link

View: New views
1 Messages — Rating Filter:   Alert me  

UPDATE over a db_link

by Zimm1 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hello,

I would like to update a table in remote database A from database B, via a db_link.

(There is no db_link from A to B, so I cannot perform the update within A, it has to be from within B db_linking to A. (Hope that makes sense)).

Does anyone know whether this is possible and if give me a rough idea of the syntax?

Many Thanks