Question: You should create and Use this table to help you : category. (catNo , catogeryName) By using PL/SQL: Create procedure to add new Category which

You should create and Use this table to help you : category. (catNo , catogeryName) By using PL/SQL: Create procedure to add new Category which use validation FUNCTION checkExistingCategory using EXCEPTION to validate category name if its not exists before, then add this category and generate the category number automatically using database trigger. ((Don't forget to use exception ))

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!

You should Use these tables to help you category. (catNo, catogery Name), Items(itemNo, ItemName, Price, total _quantity, catNo), By using PL/SQL : Create procedure to add new...

In this assignment you will complete the creation of your OVS, Inc. data warehouse database tables and then perform a number of decision support queries using the tables. You can perform this...

Project students name & id: 1 - 2 - 3 - 4 - 5 - Q 1 ) Create a complete project using SQL / PLSQL programing language to achieve the following requirement to develop point of sale system which allow...

5. Calculate BMI Category in a new column using INDEX-MATCH and the BMI category designations given. Create a lookup Excel table to provide BMI category names Underweight, Normal Weight, Overweight,...

\f\f\f\f\fCompany List Sorted Customer List Sorted Company Selection Customer Selection Sum of Sales Count of Records Company Upper Bin Frequency 600 800 1000 1200 1400 infinity Total Count Histogram...

I need help with the formulas, if you could show me the formulas that would be great! 5. Calculate BMI Category in a new column using INDEX-MATCH and the BMI category designations given. Create a...

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

Find xand test whether the two attributes are independent. Let a = 0.05. A A3 215 60 Attributes A2 Total B1 325 600 B2 400 135 175 90 350 Total 500 1000 150

The idea of assigning numerical values to determine a preference ordering over a set of objects is not limited in application to commodity bundles. The Bill James Baseball Abstract argues that a...

Suppose that the position of a particle is given by s ( t ) = 2 t 3 + 7 t + 9 . ( a ) Find the velocity at time t . v ( t ) = ms ( b ) Find the velocity at time t = 3 seconds. ms ( c ) Find the...

Use the following information for the following four questions. A financial institution wishes to earn a pure rate of 2 percent, and the inflation premium is 1.6%. The financial institution uses the...

1. Describe the types of power that effective leaders employ

2. Describe how leadership styles should be adapted to the group situation

7. Next time you work in a group, pay attention to how the group works. Does the activity follow a linear model, or is the activity punctuated by periods of inertia and periods of intense activity?...