Oracle in a Nutshell

Calls

PROCEDURE DBMS_RECTIFIER_DIFF.DIFFERENCES (sname1 IN VARCHAR2, oname1 IN VARCHAR2, reference_site IN VARCHAR2 := '', sname2 IN VARCHAR2, oname2 IN VARCHAR2, comparison_site IN VARCHAR2 := '', where_clause IN VARCHAR2 := '', {column_list IN VARCHAR2 := '' | array_columns IN DBMS_UTILITY.NAME_ARRAY}, missing_rows_sname IN VARCHAR2, missing_rows_oname1 IN VARCHAR2, missing_rows_oname2 IN VARCHAR2, missing_rows_site IN VARCHAR2:= '', max_missing IN INTEGER, commit_rows IN INTEGER := 500);

Compares the column_list or array_columns of sname1.oname1 at reference_site to sname2.oname2 at comparison_site. Inserts up to max_missing rows into missing_rows_sname.missing_rows_oname1 and information about the missing rows in missing_rows_oname2, with a commit every commit_rows.

PROCEDURE DBMS_RECTIFIER_DIFF.RECTIFY (sname1 IN VARCHAR2, oname1 IN VARCHAR2, reference_site IN VARCHAR2 := '', sname2 IN VARCHAR2, oname2 IN VARCHAR2, comparison_site IN VARCHAR2 := '', where_clause IN VARCHAR2 := '', {column_list IN VARCHAR2 := '' | array_columns IN DBMS_UTILITY.NAME_ARRAY}, missing_rows_sname IN VARCHAR2, missing_rows_oname1 IN VARCHAR2, missing_rows_oname2 IN VARCHAR2, missing_rows_site IN VARCHAR2:= '', max_missing IN INTEGER, commit_rows IN INTEGER := 500);

Resolves the differences between the two tables found with the DIFFERENCES procedure. The max_missing parameter is new with Oracle8i.