use oracle sql comand line

with method fuond or notfound

---

with table customer( customerNo, customerName , gender)

----

4) Create database package pointOfSal which contain the following

A. procedure to add new customer which use validation method checkExistingCustomer using cursor to validate customer name if its not exists before, then add this new customer