Page 1 of 1
To populate the column CUST_TYPE with the appropriate TYPE, follow the steps below: 6. Implement a PL/SQL block using th
Posted: Sat Feb 19, 2022 3:20 pm
by answerhappygod
- To Populate The Column Cust Type With The Appropriate Type Follow The Steps Below 6 Implement A Pl Sql Block Using Th 1 (19.7 KiB) Viewed 31 times
To populate the column CUST_TYPE with the appropriate TYPE, follow the steps below: 6. Implement a PL/SQL block using the IF and UPDATE statements to set the CUST_TYPE column value to 'A', 'B' or 'C' according to the rule explained above. 7. Display the whole content of the CUSTOMER_COPY table. 8. Display the number of customers, write it here...... 9. Count the number of Customers by CUST_TYPE, write it below: 1 A B с *****