Open your browser and enter the following URL:

http://localhost:1158/em/

Enter system/oracle and click Login.

Click the Administration tab.

Scroll down.

Click the Configuration link under XML Database.

Enter 2100 for FTP Port and 8080 for HTTP port. Then click OK.

Your configuration has been set. Click your Database Instance breadcrumb.

From the Administration tab, under XML Database, select the Resources link.

Click Go to see all the resources.

All the resources are displayed. Expand home.

Expand OE - PurchaseOrders - 2002 - Apr to show the list of XML documents. Click the first XML document in the list.

General information about the document is shown. To see the actual contents of the document, click Display Contents.

The file contents are shown. Click Show formatted XML Content.

Review the formatted XML document. When done, close the window.

Click the Database Instance breadcrumb.

From the Administration tab under XML Database, click XMLType Tables.

Click Go.

Click the table name PURCHASEORDER.

The definition of the XSD is displayed. Scroll down to see more information.

Double-click the <jdev_dir>\jdev\bin\jdevw.exe.

Note: You may be asked if you want to upgrade from a previous release.

Click the Connection tab. Right-click WebDAV Server in the Navigator window and select New WebDAV Connection...

At the Welcome window, click Next.

Enter WebDAVConnection1 in the Name field, http://localhost:8080/ in the URL field and click Authentication Required. Then click Next.

Enter OE for the user name and password. Then click Next.

Click Test Connection.

Your test was successful. Click Next.

Click Finish.

Expand your WebDAVConnection1 connection that you just created.

Expand home - OE - PurchaseOrders - 2002 - Apr. Double-click the first document in the list. The XML document is shown.

Scroll down in the Navigator window and double-click purchaseOrder.xsd.

The XML Schema is shown in a graphical layout. Expand the PurchaseOrder type.

Expand the Actions type.

Expand Action and you see that there are two type objects, User and Date. Now you go back to the XML Document to see where this is defined. Click the XML Document tab.

The Action object contains a user type of KPARTNER.

Open a command prompt and enter the following commands:

cd wkdir
sqlplus oe/oe

The first xquery you run selects the number of XML documents there are in total. Execute the following script:

@xquery01

The second xquery you run selects the number of XML documents for a particular user. Execute the following script:

@xquery02

The next xquery you run reviews a specific purchase order. Execute the following script:

@xquery03

The next xquery you run lists all the purchase orders who have a particular part id. Execute the following script:

@xquery04

The next xquery you run lists the description for each line item on a particular purchase order. Execute the following script:

@xquery05

From your SQLPlus session, logged in the OE user.

@createXMLIndexes

The next xquery you run reviews a specific purchase order. Execute the following script:

@xquery03

The next xquery you run lists all the purchase orders who have a particular part id. Execute the following script:

@xquery04

The next xquery you run lists the description for each line item on a particular purchase order. Execute the following script:

@xquery05

You first will create an XML view over relational tables by using a XMLTable() SQL/XML function and an XQuery expression. Execute the following script:

@createXQueryView

Now you can show XQuery over the XML view you just created. Execute the following script:

@xqueryXQLView

You first need to create a trigger that will create a virtual XML document from the previously created XML view. Execute the following script:

@folderXQDepartments

Switch to JDeveloper. From the Navigator window, right click /home/OE from your WebDAV connection and select Refresh.

Expand XQDepartments.

Note: If you receive an error at this step, try performing step 1 one more time and then expand XQDepartments again.

Double-click the first .xml document in the list. This Accounting.xml document displays XML data directly from a row in the XMLType view.

You can also query the virtual XML documents. Note the usage of XQuery standard doc() function to retrieve an XML document from the XML DB repository. First, you review the list of virtual documents that have a displayname of Accounting. Execute the following script:

@departmentsXQueries01

Now you can display the contents of one of the virtual XML documents. Execute the following script:

@departmentsXQueries02

And lastly, you can perform an XQuery to select one of the entries in the virtual XML documents. Execute the following script:

@departmentsXQueries03

Execute the following script:

@resourceViewXQuery01

The tags and other XQuery expressions have transformed purchaseorders to generate a report of a very different XML document. Execute the following script:

@xqueryTransform

Switch to JDeveloper. Click the Applications tab in the Navigator and click the Add to Applications icon.

Select XQuerySamples.jws from your <working directory>\JDBC directory. Then click Open.

Expand XQuerySamples > SimpleXQuery > Application Sources, then right-click SimpleXQuery.java and click Open.

Scroll down a bit to the OracleConnection statement and change the hostname and SID information, if needed.

Change the JDBC connection information for all the .java files under XQueryBind.

You need to set your classpath. Select Tools > Default Project Properties.

Select Libraries then click New....

Enter Oracle Database 10gR2 for the Library Name and click Edit for the Classpath.

Click Add Entry...

Navigate to the C:\oracle\product\10.2.0\db_1\jdbc\lib\ojdbc14.jar file and click Select.

Click Add Entry...

Navigate to the C:\oracle\product\10.2.0\db_1\RDBMS\jlib\xdb.jar file and click Select.

Click Add Entry...

Navigate to the C:\oracle\product\10.2.0\db_1\lib\xmlparserv2.jar file and click Select.

Click OK.

Click OK to save your new Library.

Click OK to close the Project Properties window.

Now you need to add the Library to your projects. Right-click SimpleXQuery and select Project Properties.

Select Oracle Database 10gR2 from the list of Libraries and click > to select it. Then click OK.

Right-click XQueryBind and select Project Properties.

Select Oracle Database 10gR2 from the list of Libraries and click > to select it. Then click OK.

Right-click XQuerySamples and select Make.

Review the Message window to make sure you receive no errors.

Right-click SimpleXQuery and select Run.

The output is displayed in the Log area.

Note: If you receive an error, check your path environment variable to make sure the jdk directory is specified. See Prerequisite #4.

Right-click XQueryBind and select Run.

The output is displayed in the Log area.