Question: - Import ovar_med_comp.csv file into ORACLE table and name it ovarian med comp. Write a PL/SQL program using an implicit cursor that displays all patients
- Import ovar_med_comp.csv file into ORACLE table and name it ovarian med comp. Write a PL/SQL program using an implicit cursor that displays all patients PLCO_ID, current weight, age, moderate activity and duration per week over the 12 months, income, and Number of days from randomization to the completion date in the following format if patients' cancer type is Ovarian cancer, complication summary is direct surgical, complication code is Blood loss requiring transfusion for diagnostic patients, and lung cancer family history in first-degree relatives exists. (Exclude if age and income is null.)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
