Showing posts with label sql dialog. Show all posts
Showing posts with label sql dialog. Show all posts

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.