Question: use sql command,, and use this table: Customer ( customerNo,costomerName,gender ) Create database package pointOfSal which contain the following: A. procedure to add new customer

use sql command,, and use this table:

Customer(customerNo,costomerName,gender)

Create database package pointOfSal which contain the following: A. procedure to add new customer which use validation FUNCTION CALLED "checkExistingCustomer" using cursor to validate customer name if its not exists before, then add this new customer (( PLEASE FOCUS ON THE Requirement specially the package and the function))

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

use sql command line and the table Customer( customerNo,costomer Name ,gender ) , 4) Create database package pointOfSal which contain the following A. procedure to add new customer which use...

use oracle Pl/sql command line I do not know which table to use here all tables -- The system must contain tables such as category( catNo , catogeryName ) , Items( itemNo,ItemName,Price,...

by using SQL COMMANDS ,, create and use customer table to add new customer in the Question : Customer ( customerNo,costomerName,gender ) Create database package pointOfSal which contain the following...

pls use oracle PL/sql command line ------ Q1 ) Create a complete project using SQL/PLSQL program ing language to achieve the following requirement to develop point of sale system which allow the...

pls use oracle PL/sql command line ------- Q1 ) Create a complete project using SQL/PLSQL program ing language to achieve the following requirement to develop point of sale system which allow the...

Q1 ) Create a complete project using SQL/PLSQL program ing language to achieve the following requirement to develop point of sale system which allow the Employee to add customer invoice which contain...

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....

Mom and POP database: Project 2 Based on the business requirements provided, the ERD would include the following entities: -Customers -Videos/DVDs -Movie -Distributors -Transactions Assignment to be...

Project SEE attatchment of mom and pop database In this assignment you will create the physical database from your design created in Project 2. Project 2 was a logical model of the Mom & Pop...

Project 3 In this assignment you will create the physical database from your design created in Project 2. Project 2 was a logical model of the Mom & Pop database. We need to transition the logical...

Consider the explicit formula un = 81(1/3)n-1 a. List the first six terms, u1 to u6. b. Write a recursive formula for the sequence.

Cortez Company sells chairs that are used at computer stations. Its beginning inventory of chairs was 140 units at $65 per unit. During the year, Cortez made two batch purchases of this chair. The...

what do they about "monthly vehicle lease is $400 per month, anticipated annual fuel cost is $4,000

Merrimack is an all equity firm and has a cost of capital of 8.3 percent. The firm is considering switching to a debt-equity ratio of 1.20 with a pretax cost of debt of 6.5 percent. What will the...

9. This traditional Mexican soup is made mostly from tripe, hominy, and chili: a. Tortilla soup b. Tomatillo c. Chorizo soup d. Menudo

3. What techniques do people use to assert power in communication interactions?

What is the relationship between humans and nature?