Question: I need SQL-Code to the following problems. Problem 11.1 [4] Write a procedure to add an amount of Rs.1000 for the employees whose salaries is
![I need SQL-Code to the following problems. Problem 11.1 [4] Write a](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2024/09/66f3c60f3f56e_98266f3c60ed64ca.jpg)
I need SQL-Code to the following problems.
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. Problem 12.1 [6] Write a TRIGGER to ensure that DEPT TABLE does not contain duplicate of null values in DEPTNO column. Problem 12.2 [6] Write a Trigger to carry out the following action on deleting a deptno from dept table, all the records with that deptno has to be deleted from the emp table Problem 12.3 [6] Write a Trigger to carry out the following action: on deleting any records from the emp table, the same values must be inserted into the log table
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
