Question: CREATE OR REPLACE PROCEDURE PROC _ UPDATE _ SALARY ( name varchar 2 , salary number ) AS BEGIN update employee set employee _ salary

CREATE OR REPLACE PROCEDURE PROC_UPDATE_SALARY
(name varchar2,
salary number
)
AS
BEGIN
update employee set employee_salary = salary where employee_name = name;
commit;
EXCEPTION
when others than
ROLLBACK;
END;
How many parameters this stored procedure has?

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 Programming Questions!

Q:

Question 1: Triggers and Stored Procedures: Download the file named assignment4_database.sql from D2L. Run the file from MySQL workbench, putty or Terminal. If using Metrostate login via Putty or...

Q:

Try It / Solve It 1. What is the difference between the following two pieces of code? CODE SAMPLE A DECLARE v_empid employees.employee_id % TYPE := 100 ; v_percent_increase NUMBER(2,2):=.05; BEGIN...

Q:

Attribute name Attribute Descri Attribute t each model can lift Question 1: Triggers and Stored Procedures: Database nama: C AviaCo Oace the attribute has been added, update the values of all rows as...

Q:

TEN questions about database Question 39 1. All of the following are set operations that can be performed on suitable relational tables EXCEPT A. SUM B. INTERSECTION C. DIFFERENCE D. UNION 0.5 points...

Q:

some questions about sql question 40 1. Evaluate the SELECT statements in the following SQL compound queries: SELECT emp_id FROM emp INTERSECT SELECT emp_id FROM emp_hist; SELECT emp_id FROM emp_hist...

Q:

rigger and Stored Procedure: 1 . Write Triggers that logs any changes on Salary column of Employee table. Trig _ Update _ Audit _ EmpSalary to log any changes of salary by Update Trig _ Insert _...

Q:

Database Management Systems Triggers and Stored Procedures Answer the following questions based on the above database: 1) Create a view named ATL_CHARTERS_V that includes the following For each...

Q:

Database Management Systems Question 1: Normalization Consider a relation R with six attributes ABCDEF where AB is a composite primary key for R. Assume R has the following functional dependencies (R...

Q:

Database Management Systems Question 1: Normalization Consider a relation R with six attributes ABCDEF where AB is a composite primary key for R. Assume R has the following functional dependencies (R...

Q:

Answer the following questions based on the above database: (4 Points) Create a view named ATL_CHARTERS_V that includes the following For each charter of aircraft to Atlanta (STL), print the charter...

Q:

This exercise looks into the relationship between clauses and implication sentences. a. Show that the clause (P1 V . . . V Pm VQ) iS logically equivalent to the implication sentence (P1 . . . Pm)...

Q:

Strategic analysis of operating income (continuation of 13-3D) Refer to Problem 13-30. Assume that in 2009, Dransfield has changed its processes and trained workers to recognize quality problems and...

Q:

Term Structure of Interest Rates Suppose that E , the cost of foreign currency expressed in units of local currency, is eaual to 1 . What is F 3 m o n t e s s , that is the cost of foreign currency...

Q:

Convert each angle measure to decimal degree form Round your answers to three decimal places a 105 10 54 O b 401 14 40 O