Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Write a PL/SQL script to print all the details of the Jobs table using a cursor. Your query must include %RowType (to access the column

Write a PL/SQL script to print all the details of the Jobs table using a cursor. Your query must include %RowType (to access the column names and datatypes of jobs table), and a cursor attribute to print the total number of rows returned.

image text in transcribed

DEPARTMENTS * DEPARTMENT_ID * DEPARTMENT_NAME MANAGER_ID LOCATION_ID P LOCATIONS LOCATION_ID STREET_ADDRESS POSTAL_CODE F F F * CITY * JOB_HISTORY PF * EMPLOYEE_ID P START_DATE * END_DATE F* JOB_ID F DEPARTMENT_ID STATE_PROVINCE COUNTRY_ID F EMPLOYEES P * EMPLOYEE_ID FIRST_NAME * LAST_NAME U * EMAIL PHONE_NUMBER HIRE_DATE F* JOB_ID SALARY COMMISSION_PCT F MANAGER_ID F DEPARTMENT_ID V COUNTRIES P * COUNTRY_ID COUNTRY_NAME F REGION_ID V JOBS * JOB_ID JOB_TITLE MIN_SALARY MAX_SALARY REGIONS P * REGION_ID REGION_NAME

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

SQL Server T-SQL Recipes

Authors: David Dye, Jason Brimhall

4th Edition

1484200616, 9781484200612

More Books

Students also viewed these Databases questions

Question

Give an example of a faulty dismissal.

Answered: 1 week ago

Question

How does selection differ from recruitment ?

Answered: 1 week ago