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