Database Reference
In-Depth Information
Figure 5.43
Query XML data.
1. To assemble the e-mail addresses with the customers' irst names and last names, we
need to create a temporary table called CUSTOMER_EMAIL (Figure 5.44).
2. hen, insert the assembled e-mail addresses into the temporary table CUSTOMER_
EMAIL as shown in Figure 5.45. he e-mail addresses are assembled with the columns
LastName and FirstName of the table CUSTOMER.
3. Next, insert the assembled e-mail addresses into the Email column of the table
CUSTOMER as shown in Figure 5.46.
4. he last step is to display the e-mail addresses with the XML method query() as shown
in Figure 5.47.
Figure 5.44
Create CUSTOMER_EMAIL table.
Figure 5.45
Insert e-mail addresses into e-mail column.
Search WWH ::




Custom Search