To populate the column CUST_TYPE with the appropriate TYPE, follow the steps below: 6. Implement a PL/SQL block using th
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
To populate the column CUST_TYPE with the appropriate TYPE, follow the steps below: 6. Implement a PL/SQL block using th
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 с *****
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!