Question: Problem 11.1 [4] Write a procedure to add an amount of Rs.1000 for the employees whose salaries is greater than 5000 and who belongs to

 Problem 11.1 [4] Write a procedure to add an amount of

Problem 11.1 [4] Write a procedure to add an amount of Rs.1000 for the employees whose salaries is greater than 5000 and who belongs to the deptno passed as an argument. Problem 11.2 [4] Write a T-SQL block to update the salary of the employee with a 10% increase whose empno is to be passed as an argument for the procedure. [4] Problem 11.3 Write a function to find the salary of the employee who is working in the deptno 20 (to be passed as an argument). Problem 11.4 [3] Write a function to find the nature of job of the employee whose deptno is 20(to be passed as an argument) [3] Problem 11.5 Write a T-SQL block to obtain the department name of the employee who works for deptno 30

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!