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.