3. Attempt to remove every row in the table by omitting a WHERE clause:
P AR T II
delete from products;This will fail, due to a constraint violation because there are child records
in the ORDER_ITEMS table that reference PRODUCT_ID values in the
PRODUCTS table via the foreign key constraint FK_PRODUCT_ID.
Bạn đang xem 3. - OCA OCP ORACLE DATABASE 11G A LL IN ONE EXAM GUIDE P37 DOC