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 the Bonus table:

CREATE TABLE BONUS (
 ENAME               VARCHAR2(10),
 JOB                 VARCHAR2(9),
 SAL                 NUMBER,
 COMM                NUMBER);

Data for SALGRADE Table:

CREATE TABLE SALGRADE (
 GRADE               NUMBER,
 LOSAL               NUMBER,
 HISAL               NUMBER);
INSERT INTO SALGRADE VALUES (1,700,1200);
INSERT INTO SALGRADE VALUES (2,1201,1400);
INSERT INTO SALGRADE VALUES (3,1401,2000);
INSERT INTO SALGRADE VALUES (4,2001,3000);
INSERT INTO SALGRADE VALUES (5,3001,9999);

Answer 1

This is table one schema

<Table>
<Employee>
<FirstName>xy</FirstName> <LastName>xy</LastName> <ContactNo>1234567890</ContactNo> <Email>[email protected]</Email> <Address> <City>Bangalore</City> <State>aaa</State>
<Zip>66666</Zip>
</Address>
</Employee>
</Table>

This is table two schema

<Table>
<department>
<dname>yyy1</dname> <ContactNo>1234567890</ContactNo> <hod>@xyz.com</hod>
</department>
</Table>

This is third schema

<Table>
<Order>
<orderno>1001</orderno>
</Order>
</Table>

This is fourth schema

<Table>
<Poduct>
<product no>1001<product no>
<product nname>1001<product name>
</Product>
</Table>

This is last schema

<Table>
<Price>
<price>1001</price>
<product nname>1001</product name>
</Price>
</Table>