Question: 0 - Given is the relational table PATIENT. PLCO _ ID Age Num _ of _ days Income A - 0 0 0 8 9

0- Given is the relational table PATIENT.
PLCO_ID
Age
Num_of_days
Income
A-000899-
7
76
3457
2000
A-000998-
8
70
2774
3500
A-001799-
7
83
3359
2750
A-001899-
7
69
2322
2950
The PATIENT_ML contains a single column OnePatient that contains PLCO_ID, Age, Num_of_days, and Income attributes of PATIENT.
create table complication_xml (
OnePatient xmItype);/
a)(10 points) Write an insert statement (JUST ONE) that will insert the first row of the table PATIENT into complication_xml.
b)(20 points) Assume that all rows are inserted into the complication_ml. Write a PL/SQL program using an implicit cursor that displays on the screen all the rows in the table complication_xml.

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!