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

Data base 2 Question 1: in the following PL/SQL code, fixed the

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!