Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

Re: How to Compare Data in 2 Separate Databases

by malloc (Pilgrim)
on Nov 30, 2001 at 05:13 UTC ( [id://128523]=note: print w/replies, xml ) Need Help??


in reply to How to Compare Data in 2 Separate Databases

AFAIK, you definitely need the dblink to be there already when accessing across databases in Oracle. But you can always just use two DataBase Handles, spool the data from both db's with the same query run on both $dbh's to two data structures in Perl, and compare those. Good Luck!

-malloc
  • Comment on Re: How to Compare Data in 2 Separate Databases

Replies are listed 'Best First'.
Re: Re: How to Compare Data in 2 Separate Databases
by hakkr (Chaplain) on Nov 30, 2001 at 15:20 UTC
    The SQL commands JOIN or UNION may make this easier for you.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://128523]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others chanting in the Monastery: (2)
As of 2024-04-20 04:21 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found