Hi,
I was looking at an optimized way in pl/sql to compare the data from tables in two different databases (Oracle 9i). Is there any alternate to opening cursors for each of the two tables and looping through them?
Thank you.
Printable View
Hi,
I was looking at an optimized way in pl/sql to compare the data from tables in two different databases (Oracle 9i). Is there any alternate to opening cursors for each of the two tables and looping through them?
Thank you.
select * from table_1Quote:
Originally Posted by raghu_vnin
minus
select * from table_2
UNION ALL
select * from table_2
minus
select * from table_1
will do
Tamil
Use DBMS_RECTIFIER_DIFF package.
Sergey