2-Views.txt

SQL Workshop
Object Browser
Create
View
Create View 


CREATE OR REPLACE FORCE VIEW  "PRODUCT_VIEW" ("PRODUCTID", "PRODUCTNAME", "SALESPRICE", "CATEGORYNAME") AS 
  select PRODUCTID, PRODUCTNAME, SALESPRICE, CATEGORYNAME from PRODUCT
inner join CATEGORY on PRODUCT.CATEGORYID = CATEGORY .CATEGORYID
where SALESPRICE > 1000;