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';
No Format |
---|
select count(*) from sfrstcr@banner where SFRSTCR_TERM_CODE = '200710';
select count(*) from banner_enrollment where term_code = '200710';
|