Chapter $14$ Individual Assignment: Using an Object Table of XMLType in Oracle

Step $14\mathrm{.}1-$ Open the text file called: Chapter$\_14\_$Individual$\_$Assignment$\_$Using$\_$an$\_$Object$\_$Table$\_$of$\_$XMLTYPE.txt

Step $14\mathrm{.}2-$ Copy each SQL statement and paste them into SQL$*$Plus at the SQL$>$ prompt to see an example of creating and using an Oracle Object Table of XMLType called Customers.

Note: Log into the Oracle Database as your Oracle User ID to run all of the statements in the text file $($Do not use SYS or SYSTEM for this step$).$

Note: Show your work by providing screenshots that include the current user id$,$ current system date, executing the SQL statements in the database, and the results. To display the current user and current date, run the following statement before running the SQL statements:

SQL$>$ select user$||\text{'}\text{'}||$sysdate from dual;

Step $14\mathrm{.}3$ Design an Oracle Object Table of XMLType called Employees. Then create the Oracle Object Table of XMLType in the database.

Note: Use your Oracle User ID to create the Employees table $($Do not use SYS or SYSTEM for this step$).$

Note: Show your work by providing screenshots that include the current user id$,$ current system date, executing the SQL statements in the database, and the results.

Step $14\mathrm{.}4-$ Design $3$ Insert SQL statements using XML format. Then insert the $3$ records into the table. Table attributes should include: employee$\_$id$,$ employee$\_$name, employee$\_$address, employee$\_$telephone, employee$\_$job$\_$title, employee$\_$salary.

Note: Use your Oracle User ID to run the Inserts into the Employees table $($Do not use SYS or SYSTEM for this step$).$

Note: Show your work by providing screenshots that include the current user id$,$ current system date, executing the SQL statements in the database, and the results.

Step $14\mathrm{.}5-$ Design $5$ Select SQL statements using the example in Step $14\mathrm{.}1$ as a guide. Then execute the $5$ SQL statements in the database.

Note: Show your work by providing screenshots that include the current user id$,$ current system date, executing the SQL statements in the database, and the results.

Note: To display all of the data properly, run the following $2$ statements after you log into the Oracle Database as your Oracle User ID $($before running the five query statements$)$:

SET LONG $10000$

SET PAGESIZE $10014.$a $-$ Creating an Object Table of XMLType

create table Customers of XMLtype;

$--14.$b $-$ Inserting into an XMLType Table

insert into customers values$($XMLType$($

$\text{'}$

WorldWide Travel Agency