Question: 2- Create table LYMPHOMA_JSON in Oracle. It should contain a single column LYMPHOMAJSON. Then, write a PL/SQL code using implicit cursor that reads from LYMPHOMA

2- Create table LYMPHOMA_JSON in Oracle. It should contain a single column LYMPHOMAJSON. Then, write a PL/SQL code using implicit cursor that reads from LYMPHOMA and write into LYMPHOMAJSON file that contains PLCO_ID, Age level, 25- hydroxyvitamin D Measure (ng/ml), matched cell value, sample draw days, season, time, and year for male patients whose matched cell value is greater than 90, age level between 2 and 3, 25-hydroxyvitamin D Measure (ng/ml) is less than 25. Copy and paste the complete PL/SQL code at the first red arrow below. (Edit the code so that it is NICELY indented.) Do a SNIP or screen dump to show the first 10 rows of the LYMPHOMA_JSON file at the second arrow .

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!