Question: Data base 2 Question 1: in the following PL/SQL code, fixed the code and execute. DSCTARS CURSOR el IS sstsct last name, salary, hire_date, job_id
Data base 2

Question 1: in the following PL/SQL code, fixed the code and execute. DSCTARS CURSOR el IS sstsct last name, salary, hire_date, job_id FRoM amployees WrRs employee 1d=120; employee_red e1 *ROWTYPg: BEGIN OPEN al: FETCH ol INTO employee red; DRMS_oUTPUT.PUT_IINE ('Employee name: ' I employee_rec.last_name) ; CLOSE a1: END ; Question 2: create PL/SQL block that the shows the employees who were hire date is last year
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
