Chapter 7 WORKING WITH VIEWS 429 (Product_ID, Product)
Chapter 7 WORKING WITH VIEWS 429 (Product_ID, Product) VALUES ( 1 , Zcheese ) INSERT Product1 (Product_ID, Product) VALUES ( 5 , AustralianJam ) INSERT Product2 (Product_ID, Product) VALUES ( 60 , SpicyDelights ) INSERT Product2 (Product_ID, Product) VALUES ( 69 , FarEastSpecialty ) INSERT Product3 (Product_ID, Product) VALUES ( 120 , DelicateClam ) INSERT Product3 (Product_ID, Product) VALUES ( 140 , FishNChips ) 4. Now, to create a partitioned view that collects all this information, execute the following code as shown in Figure 7.16. CREATE VIEW AllProducts AS SELECT * FROM Product1 UNION ALL SELECT * FROM Product2 UNION ALL SELECT *
For high quality website hosting services please check java web hosting website.