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
Get step-by-step solutions from verified subject matter experts
