Oracle XML Publisher Template Builder - SQL Dialog

SQL Dialog

The SQL dialog allows you to specify a SQL query and an Oracle Database connection to create the XML for the Template Builder. The XML is created in a canonic flat format:

<ROWSET>

            <ROW>

                        <COLUM_NAME>Data</COLUM_NAME>

            </ROW>

</ROWSET>

On the DATA menu select SQL… to open the Insert SQL dialog. All fields in this dialog are mandatory.

Oracle XML Publisher Template Builder - Option Dialog

Option Dialog

The option dialog allows you to define some options for XML Publisher.

OK Button:  Click the OK button to confirm your changes to the options.

Oracle XML Publisher Template Builder - Insert Field Dialog

Insert Field Dialog

This dialog allows you to select data elements defined in the data source (that is, the XML file) and insert them into the template. From the Insert menu select Field… to open the insert element dialog.