Question

Create an XML document for the Oracle Starter Database Tables (i.e., emp, dept, ord, product, price). Each XML document must be in the format as described in the "Mapping tables to XML" section on pg. 1161 (any column that does not have a value can be displayed as empty, e.g., <DEGREE></DEGREE> ). The name for each document will be the name of the table followed by ".xml" as the file extension (e.g., "emp.xml").

Data for PRODUCT Table:

CREATE TABLE PRODUCT (
 PRODID              NUMBER (6) CONSTRAINT PRODID_PK PRIMARY KEY,
 DESCRIP             VARCHAR2 (30));

INSERT INTO PRODUCT (PRODID, DESCRIP)
 VALUES ('100860', 'ACE TENNIS RACKET I');
INSERT INTO PRODUCT (PRODID, DESCRIP)
 VALUES ('100861', 'ACE TENNIS RACKET II');
INSERT INTO PRODUCT (PRODID, DESCRIP)
 VALUES ('100870', 'ACE TENNIS BALLS-3 PACK');
INSERT INTO PRODUCT (PRODID, DESCRIP)
 VALUES ('100871', 'ACE TENNIS BALLS-6 PACK');
INSERT INTO PRODUCT (PRODID, DESCRIP)
 VALUES ('100890', 'ACE TENNIS NET');
INSERT INTO PRODUCT (PRODID, DESCRIP)
 VALUES ('101860', 'SP TENNIS RACKET');
INSERT INTO PRODUCT (PRODID, DESCRIP)
 VALUES ('101863', 'SP JUNIOR RACKET');
INSERT INTO PRODUCT (PRODID, DESCRIP)
 VALUES ('102130', 'RH: "GUIDE TO TENNIS"');
INSERT INTO PRODUCT (PRODID, DESCRIP)
 VALUES ('200376', 'SB ENERGY BAR-6 PACK');
INSERT INTO PRODUCT (PRODID, DESCRIP)
 VALUES ('200380', 'SB VITA SNACK-6 PACK');

Answer 1

XML Document for Oracle Table

As per the given details and table description, the XML document craeted for Product table will be:

Product.xml

<?xml version="1.0"?>
<PRODUCTS>
<PRODUCT>
<PRODID>100860</PRODID>   
<DESCRIP>ACE TENNIS RACKET I</DESCRIP>
</PRODUCT>
<PRODUCT>
<PRODID>100861</PRODID>   
<DESCRIP>ACE TENNIS RACKET II</DESCRIP>
</PRODUCT>
<PRODUCT>
<PRODID>100870</PRODID>   
<DESCRIP>ACE TENNIS BALLS-3 PACK</DESCRIP>
</PRODUCT>
<PRODUCT>
<PRODID>100871</PRODID>   
<DESCRIP>ACE TENNIS BALLS-6 PACK</DESCRIP>
</PRODUCT>
<PRODUCT>
<PRODID>100890</PRODID>   
<DESCRIP>ACE TENNIS NET</DESCRIP>
</PRODUCT>
<PRODUCT>
<PRODID>101860</PRODID>   
<DESCRIP>SP TENNIS RACKET</DESCRIP>
</PRODUCT>
<PRODUCT>
<PRODID>101863</PRODID>   
<DESCRIP>SP JUNIOR RACKET</DESCRIP>
</PRODUCT>
<PRODUCT>
<PRODID>102130</PRODID>   
<DESCRIP>RH: "GUIDE TO TENNIS"</DESCRIP>
</PRODUCT>
<PRODUCT>
<PRODID>200376</PRODID>   
<DESCRIP>SB ENERGY BAR-6 PACK</DESCRIP>
</PRODUCT>
<PRODUCT>
<PRODID>200380</PRODID>   
<DESCRIP>SB VITA SNACK-6 PACK</DESCRIP>
</PRODUCT>
</PRODUCTS>

In the above Product.xml document the root element(parent) is '<PRODUCTS>' and under this element, all the Product records are written in separate <PRODUCT> blocks.

As you did not provide the other table details and exact file format of your section, I couldn't include the other documents of tables  (i.e., emp, dept, ord, price) here. You can follow the same format for all other tables according to their number of fields and populate the data to those elements of your need.

Kindly Note: - Please make sure you are included all the relevant details like complete table structure and data for the better and accurate solution.