Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create a PL/SQL block that uses data in the company database to do the following tasks: 1) Retrieve information about an employee and print
Create a PL/SQL block that uses data in the company database to do the following tasks: 1) Retrieve information about an employee and print it as follow: Current Salary: Employee's SSN: Name: Department Number: Department Name: Manager's Name: Current Salary: The program should assign a value or prompt for employee's SSN (such as 123456789, 333445555, or 999887777). Department # 1 4 2) Update that employee's salary information in the database after the raise is calculated. The percentage of the raise is based on the department he/she works for. The following shows the percentage of raise for each department: 5 The SQL syntax for update is: 123456789 John B. Smith 5 Research Franklin Wong 30,000.00 Salary after the raise: Employee's SSN: Name: Department Number: Department Name: Manager's Name: Current Salary: UPDATE table name SET column1 = value1, column2 = value2...., columnN = valueN WHERE [condition]; Print the new salary information. Thus, the updated information should look like this: % Raise 3 5 7 123456789 John B. Smith 5 Research Franklin Wong 32,100.00 3) Reset the salary in the database back to the original (Also, use the "update table ... "command). Print the salary information again. Thus the final information should look like this: Current Salary: Employee's SSN: Name: Department Number: Department Name: Manager's Name: Current Salary: 123456789 John B. Smith 5 Research Franklin Wong 30,000.00 Note: Do all of these steps in one program!
Step by Step Solution
★★★★★
3.37 Rating (150 Votes )
There are 3 Steps involved in it
Step: 1
The image you sent shows a diagram of a social media data warehouse A data warehouse is a central repository for all of the data that a social media c...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