Question: show PL/SQL program that uses ONLY the tablePATIENT_XML and does NOT use the tablePATIENT or any other table or any other view. Zero points if

show PL/SQL program that uses ONLY the tablePATIENT_XML and does NOT use the tablePATIENT or any other table or any other view. Zero points if you do not follow these rules.

This program should send the complete tablePATIENT_XML to the screen in the following format:

PLCO_ID is A-002879-7

Age is 75

Days to the completion is 4337

Income is 2

Current BMI is $20,000-$49,000

Current height is 64

PLCO_ID is A-002878-7

Age is 78

Days to the completion is 2350

Income is$50,000-$99,000

Current BMI is 2

Current height is 72

Etc. etc.

Note the empty line. There has to be an empty line after every new table row. Every table row becomes 6 lines + 1 empty line after.

Note that all the "is" are lined up in the same column. It has to be that way.

Show the program at the first red arrow below.

Show the first 10 lines of the result at the second red arrow below.

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!