|
Say, if I want to update many databases at once, or if I want to query many database targets at once?
(comments are locked)
|
|
If you have Toad for Oracle, it's Script Manager has the ability to launch multiple queries/scripts against multiple databases.
(comments are locked)
|
|
A PL/SQL procedure that uses dynamic SQL to execute the query on several databases by iterating over an array of database links? Sounds like a plausible solution. Thanks. Has anyone had to do this before? (and therefore might have an example script?)
Nov 02 '09 at 12:00 PM
David Atkinson
(comments are locked)
|
Your answer
