2- Create table LYMPHOMA_JSON in Oracle. It should contain a single column LYMPHOMAJSON. Then, write a PL/SQL
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 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 .
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill