December 2002
Intermediate to advanced
928 pages
85h 29m
English
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.