Databases Reference
In-Depth Information
{%ADAM_SALES}{enabled:False}</replace>
<replace token="{$brentSales}">
{%BRENT_SALES}{enabled:False}</replace>
</action>
</actions>';
dbms_lob.writeappend( l_chart, length(l_chart_v), l_chart_v);
select xmlagg( xmlelement("point", xmlattributes(p.c1 as "name", p.c2 as "y"),
(select xmlelement("attributes", xmlagg( xmlelement("attribute", xmlattributes
(t.c3 as "name"), t.c4)))
from salespp t
where t.c1=p.c1))).getclobval()
into l_chart_data
from (select distinct c1,c2 from salespp) p;
dbms_lob.append(l_chart, l_chart_data);
l_chart_v := '
</series>
</data>
</chart>
<chart plot_type="CategorizedHorizontal" name="productsChart">
<chart_settings>
<title>
<text>By Products</text>
</title>
<axes>
<y_axis position="Opposite">
<title enabled="False"/>
<labels>
<format>${%Value}{scale:(1000)|(k),numDecimals:0}</format>
</labels>
</y_axis>
<x_axis>
<title enabled="False"/>
</x_axis>
</axes>
<chart_background>
<border type="Solid" color="#CCCCCC" thickness="1"/>
<corners type="Square"/>
<effects enabled="false"/>
<inside_margin all="10" top="5"/>
</chart_background>
</chart_settings>
<data_plot_settings>
<bar_series>
<tooltip_settings enabled="True">
<format>
{%Name}
${%Value}{numDecimals:2}
</format>
