Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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