1. How would one compose a PL/SQL Trigger that will fires when a row is deleted in the PRODUCTS table? The trigger should delete the row from the PRODUCT_STATS table based on the shared product_id.

 

Language SQL V D C 1 select PRODUCTS.PRODUCT_ID as PRODUCT_ID 2 from PRODUCTS PRODUCTS 3 SELECT p.product_id 4 FROM products p , product_stats ps WHERE p. product_id = ps.product_id; CREATE [ OR REPLACE ] TRIGGER id_delete AFTER DELETE 5 6 7 8 9 10 11 12 Q on PRODUCTS FOR EACH ROW DECLARE Rows 10 A:: Results Explain Describe Saved SQL History Enter SQL statement or PL/SQL command and click Run to see the results. Clear Command Find Tables Save Run