Question: 3) Write a PL/SQL program using an explicit cursor that displays all ovarian patient's PLCO ID numbers, days until procedure, and link year values from
3) Write a PL/SQL program using an explicit cursor that displays all ovarian patient's PLCO ID numbers, days until procedure, and link year values from the ovarian diagnostic table on the screen in decreasing order by the days until procedure if the patients' procedure is biopsy and diagnostic and interval status of the linked cancer is Screen Dx. Show the program at the first red arrow. Show at least 10 rows of the result at the second red arrow by snipping them. [5]
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
