Creating charts using the Oracle BI Publisher Word Template Builder is fairly straightforward. Once you've got your XML input data you simply load it within Word and run the chart wizard.

If the wizard creates the chart you want then you are lucky. Modifying the chart or doing any customisation usually involves editing the raw XML definition. However, there is almost no decent documentation available for tweaking the XML and is something of a black art.

So I created the Oracle BI Publisher Chart Generator.

If you attempt to run SQL queries in a SQL worksheet and that query includes ampersands then SQL Developer will prompt you for bind variable values. It assumes anything starting with an ampersand must be a bind variable.

For example the query below :

SELECT * FROM TBL_COLOURS WHERE colour = 'Red&Blue';

would result in a pop-up window asking for a value for "&Blue".