Run the SQL in the Ad Hoc command window to the right.

Create a table called BOOKS

The BOOKS table has five columns. The AUTHOR and TITLE columns are both in VARCHAR and the BOOKINFO column is in XML data type.

Populate the table with data

the BOOKS table is populated with a mixture of INTEGER, VARCHAR, and XML data.