(A) What Is a Named Block in PL/SQL and How $\underline{custNo}$

Essay

(a) What is a named block in PL/SQL and how many types does PL/SQL support?
(b) Specify the general structure of an anonymous block.
(c)Assume that the following tables are part of a Company database schema
Customer( $\underline{custNo}$ , custName, address, sex, DOB, creditLimit)
HighCredit( $\underline{hcCustNo}$ , hcCustName, hcCreditLimit)
Create a PL/SQL procedure object in your schema. Using a Cursor the procedure code should be able to retrieve records of all customers and check their credit limit. If a customer credit limit is greater than 100000 the procedure should insert a record in the table HighCredits.
(d) Invoke the procedure from SQL*Plus.