show PL/SQL program that uses ONLY the tablePATIENT_XML and does NOT use the tablePATIENT or any other
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 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.
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill