reate a Pl/SQL block using FOR UPDATE cursor to Update the Order_Status of all the orders to 99 who are obsolete (this is Product_status in products table) Products on order. Display the total number of orders effected using the select statement.

DE PRODUCT_INFORMATION 0 PRODUCT_ID PRODUCT_NAME PRODUCT_DESCRIPTION I CATEGORY_ID - WEIGHT_CLASS I WARRANTY PERIOD 1 SUPPLIER_ID PRODUCT_STATUS 1 LIST_PRICE MIN_PRICE " CATALOG_URL REGIONS RENTALS # TEMP REGIONS 1 REGION_ID - REGION_NAME + RENTALS # E TEMP #-0 WAREHOUSES + # RENTALS TEMP WAREHOUSES I WAREHOUSE_ID 1 WAREHOUSE_NAME LOCATION_ID L 60 CUSTOMERS CUSTOMER_ID CUST_FIRST_NAME II CUST_LAST_NAME 1 CUST_ADDRESS 10 PHONE_NUMBERS NLS_LANGUAGE CUST NLS_TERRITORY CREDIT_LIMIT 1 CUST_EMAIL L ACCOUNT_MGR_ID END LOOP; COMMIT; END; QUESTION 2: Create a PL/SQL Block that will use a Record variat shown below in Screen Capture below. Test the blo Script Output x O O S Task completed in 5.247 seconds order_id : 2444 order_date : 27-JUL-99 order_mode : direct order_status : 1 order_total :77727.2 PL/SQL procedure successfully completed. DE PRODUCT_INFORMATION 0 PRODUCT_ID PRODUCT_NAME PRODUCT_DESCRIPTION I CATEGORY_ID - WEIGHT_CLASS I WARRANTY PERIOD 1 SUPPLIER_ID PRODUCT_STATUS 1 LIST_PRICE MIN_PRICE " CATALOG_URL REGIONS RENTALS # TEMP REGIONS 1 REGION_ID - REGION_NAME + RENTALS # E TEMP #-0 WAREHOUSES + # RENTALS TEMP WAREHOUSES I WAREHOUSE_ID 1 WAREHOUSE_NAME LOCATION_ID L 60 CUSTOMERS CUSTOMER_ID CUST_FIRST_NAME II CUST_LAST_NAME 1 CUST_ADDRESS 10 PHONE_NUMBERS NLS_LANGUAGE CUST NLS_TERRITORY CREDIT_LIMIT 1 CUST_EMAIL L ACCOUNT_MGR_ID END LOOP; COMMIT; END; QUESTION 2: Create a PL/SQL Block that will use a Record variat shown below in Screen Capture below. Test the blo Script Output x O O S Task completed in 5.247 seconds order_id : 2444 order_date : 27-JUL-99 order_mode : direct order_status : 1 order_total :77727.2 PL/SQL procedure successfully completed