Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create a Pl/SQL subprogram, which has two blocks. An outer block declares two variables named x and counter and loops four times. Inside this loop
Create a Pl/SQL subprogram, which has two blocks. An outer block declares two variables named x and counter and loops four times. Inside this loop is a sub-block that also declares a variable named x. The values inserted into the temp table show that the two X 's are indeed different. You will have to create the table temp as follows: CREATE TABLE TEMP NUM_ONE NUMBER(5), NUM_TWO NUBBER(2) CHAR_OUT VARCHAR2(30)); A PL/SQL is needed to calculate annual raises and update employee salary amounts recorded in the EMP table. Create a block that addresses the requirements below. Note that all salaries in EMP table are recorded as monthly amounts. Display the calculated salaries for verification before including the update action. - Calculate 5% annual raises for all employees except AD_VP. - If the 5% totals to more than 2000 , cap the raise to 2000 . - Update the salary for each employee in the table. - For each employee display the current annual salary, raise, and proposed new annual salary. - At the end, show the total amount of salary increase. NOTE: Create the table EMP as a copy of Employee table as follow: Create table emp (empno, ename, saliob) As( select employee id furst namel|' '|last namesalary,job id from employees) Use control Structure to write a program to display the language spoken by natives of the country. Input the name of the country and display the language spoken by the natives of the country. You can use any structure of your choice. 2uestion \# 4: 5 Marks Write a PL/SQL program (Using Cursors) which calculates the number of years and employee has worked in the company. Display this information only for the employees who are working in the Sales department. Your output should be similar to following. Script Output x Task completed in 0.031 seconds anonymous block completed The Den has worked in the company is 19 Years The Alexander has worked in the company is 19 Years The Shelli has worked in the company is 16 Years The Sigal has worked in the company is 17 Years The Guy has worked in the company is 15 Years Write a PL/SQL program (Using Cursors) to list all the Managers from the employee's table with list of the Employees reporting to the Manager. Both managers and Employees reporting to the managers should be listed in alphabetical order.Qutput should list following information For manager: 1. First name 2. Last name 3. Department name Employees reporting to Manager 1. First name 2. Last name 3. Department name
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started