Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-02 |
|
|
View PDF |
Syntax
Purpose
XMLPI
generates an XML processing instruction using identifier
and optionally the evaluated result of value_expr
. A processing instruction is commonly used to provide to an application information that is associated with all or part of an XML document. The application uses the processing instruction to determine how best to process the XML document.
The optional value_expr
must resolve to a string. If you omit value_expr
, then a zero-length string is the default. The value returned by the function takes this form:
<?identifier string?>
XMLPI
is subject to the following restrictions:
The identifier
must be a valid target for a processing instruction.
You cannot specify xml
in any case combination for identifier
.
The identifier
cannot contain the consecutive characters ?>
.
See Also:
Oracle XML DB Developer's Guide for more information on this functionExamples
The following statement uses the DUAL
table to illustrate the use of the XMLPI
syntax:
SELECT XMLPI(NAME "Order analysisComp", 'imported, reconfigured, disassembled') AS "XMLPI" FROM DUAL; XMLPI -------------------------------------------------------------------------------- <?Order analysisComp imported, reconfigured, disassembled?>
The following fragment instructs the application (for example, a browser) to display the XML document using the cascading stylesheet test.css
:
<?xml-stylesheet type="text/css" href="test.css"?>