CREATE OR REPLACE FORCE VIEW "VIEW_COUNT" ("TOTALCOUNT") AS select count(p.PRODUCT_ID) TotalCount from DEMO_PRODUCT_INFO P/