Versions Compared

Old Version 1

changes.mady.by.user Thomas Amsler

Saved on

compared with

New Version Current

changes.mady.by.user Thomas Amsler

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

MViews

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