create a pl/sql block containing an update statement, to update the quantity for order_id 2410 to 300. add an appropriate code using exception to trap the check constraint violation and display the desired message as shown in screen capture below.

QUESTION 3: Create a PL/SQL Block containing an Upda Order_id 2410 to 300. Add an appropriate Constraint violation and display the desired me In order for the code to work add the Check cc ALTER TABLE order_items ADD CONSTRAINT items_qty_ck CHE Script Output 8 9 Task completed in 0.533 seconds Check Quantity, It should be less than 250 PL/SQL procedure successfully completed. QUESTION 4: Create a PL/SQL Block to determine the shipp of items ordered and NLS TERRITORY of the in the table below for the Territories other tha applied. Test the Block using Order_id's 245 the screen captures shown below. Order Quantity SHIN