[solved]-Use Hr Database Assignment Q1 Write Pl Sql Procedure Retrieve Employee Id Last Name Salary Q39048569
Use HR database for this assignment Q1. Write PL/SQL procedure that retrieve the employee id, last name and salary of employee number 100. (1 Screenshot). Execute your procedure and display the result(1 Screenshot) Q2. Create a procedure called ADD REGION on the C REGIONS that include two parameters p_region id and p_region name to insert a new region into the C REGIONS table. (1 Screenshot). Invoke the procedure by providing the REGION ID and name title using two parameters and display the output. (1 Screenshot) Note: Copy region table from hr first before creating and executing your procedure by running following statement: Create table c_regions as select * from hr.regions Q3. Create and compile a function called GET_employee_LN on the C_EMPLOYEES that prompt the user to enter employee id to return a employee last name. (1 Screenshot). Invoke the function by providing the employee id and display the output(1Screenshot). Note: Copy employees table from hr first before creating and executing your procedure by running following statement: Create table c_employees as select from hr employees Q4. Create a trigger called SALARY_TRIG on the C EMPLOYEES table that fires on each row before DELETE or UPDATE of the Salary of the Job id ‘SH CLERK (1 Screenshot). Test your trigger by providing delete or update statement and display the output (1 Screenshot). Note: Copy employees table from hr first before creating and executing your procedure by running following statement: Create table c_employees as select * from hr.employees Show transcribed image text Use HR database for this assignment Q1. Write PL/SQL procedure that retrieve the employee id, last name and salary of employee number 100. (1 Screenshot). Execute your procedure and display the result(1 Screenshot) Q2. Create a procedure called ADD REGION on the C REGIONS that include two parameters p_region id and p_region name to insert a new region into the C REGIONS table. (1 Screenshot). Invoke the procedure by providing the REGION ID and name title using two parameters and display the output. (1 Screenshot) Note: Copy region table from hr first before creating and executing your procedure by running following statement: Create table c_regions as select * from hr.regions Q3. Create and compile a function called GET_employee_LN on the C_EMPLOYEES that prompt the user to enter employee id to return a employee last name. (1 Screenshot). Invoke the function by providing the employee id and display the output(1Screenshot). Note: Copy employees table from hr first before creating and executing your procedure by running following statement: Create table c_employees as select from hr employees Q4. Create a trigger called SALARY_TRIG on the C EMPLOYEES table that fires on each row before DELETE or UPDATE of the Salary of the Job id ‘SH CLERK (1 Screenshot). Test your trigger by providing delete or update statement and display the output (1 Screenshot). Note: Copy employees table from hr first before creating and executing your procedure by running following statement: Create table c_employees as select * from hr.employees
Expert Answer
Answer to Use HR database for this assignment Q1. Write PL/SQL procedure that retrieve the employee id, last name and salary of em… . . .
OR
