Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Jeffrey A. Hoffer Fred R. McFadden

4th Edition

0805360476, 978-0805360479

More Books

Students also viewed these Databases questions

Question

Specify the moment estimators for and for the gamma distribution.

Answered: 1 week ago

Question

Discuss the goals of financial management.

Answered: 1 week ago