Oracle Integrity Checks

Owned by Thomas Amsler
Last updated: Sept 25, 2007Version comment
1 min read

MViews

  • Counting objects in both the source as well as the MView table 
    • select count(*) from sfrstcr@banner where SFRSTCR_TERM_CODE = '200710';
select count(*) from banner_enrollment where term_code = '200710';