Thanks.
I need a way to do everything in the client - that is plsql developer.
No privileges to create tables or database links in the instance / schema. Currently, I spool results to 2 separate text files and have a small Perl script to tell me the diffs.
Can I do the following from plsql developer.
I have login for both databases. thanks.
select cust_name from oracle@chicago.world
where cust_name
not in ( select cust_name from oracle@newyork.world )