Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\bldapp_chrt_about.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <title>About Creating SQL Queries for Charts</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-14T16:11:29Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="About Creating SQL Queries for Charts" /> <meta name="relnum" content="Release 3.2" /> <meta name="partnum" content="E11947-01" /> <link rel="copyright" href="dcommon/html/cpyr.htm" title="Copyright" type="text/html" /> <link rel="stylesheet" href="dcommon/css/blafdoc.css" title="Oracle BLAFDoc" type="text/css" /> <link rel="contents" href="toc.htm" title="Contents" type="text/html" /> <link rel="up" href="preface.htm" title="Home" type="text/html" /> <link rel="up" href="app_comp.htm" title="Adding Application Components" type="text/html" /> <link rel="up" href="bldapp_chrt.htm" title="Creating Charts" type="text/html" /> <link rel="up" href="bldapp_chrt_about.htm" title="About Creating SQL Queries ..." type="text/html" /> <link rel="prev" href="bldapp_chrt_type.htm" title="Previous" type="text/html" /> <link rel="next" href="bldapp_chrt_html.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface.htm" title="Home">Home</a> > <a href="app_comp.htm" title="Adding Application Components">Adding Application Components</a> > <a href="bldapp_chrt.htm" title="Creating Charts">Creating Charts</a> > About Creating SQL Queries ...</p> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr valign="bottom"> <td align="left"></td> <td align="center"><a href="bldapp_chrt_type.htm"><img src="dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="bldapp_chrt_html.htm"><img src="dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BCEIJJID" name="BCEIJJID"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1><a name="HTMDB25415" id="HTMDB25415"></a>About Creating SQL Queries for <a id="sthref1125" name="sthref1125"></a>Charts</h1> <p>You <a id="sthref1126" name="sthref1126"></a><a id="sthref1127" name="sthref1127"></a><a id="sthref1128" name="sthref1128"></a>define a chart in Application Builder using a wizard. For most chart wizards, you select a chart type and provide a SQL query using the following syntax:</p> <pre xml:space="preserve" class="oac_no_warn"> SELECT link, label, value FROM ... </pre> <p>Where:</p> <ul> <li> <p><code>link</code> is a URL.</p> </li> <li> <p><code>label</code> is the text that displays in the bar.</p> </li> <li> <p><code>value</code> is the numeric column that defines the bar size.</p> </li> </ul> <p>For example:</p> <pre xml:space="preserve" class="oac_no_warn"> SELECT <code>null</code>, last_name, salary FROM employees WHERE DEPARTMENT_ID = :P101_DEPARTMENT_ID </pre> <div align="center"> <div class="inftblnote"><br /> <table class="Note oac_no_warn" summary="" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p class="notep1">Note:</p> Do not change the type of an existing chart. Instead, delete the existing chart and then re-create it.</td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnote" --></div> <a id="sthref1129" name="sthref1129"></a> <p class="subhead2">Dial Chart<a id="sthref1130" name="sthref1130"></a><a id="sthref1131" name="sthref1131"></a> Syntax</p> <p>To create a dial chart, select a dial chart type and provide a SQL query using the following syntax:</p> <pre xml:space="preserve" class="oac_no_warn"> SELECT value , maximum_value [ ,low_value [ ,high_value] ] FROM ... </pre> <p>Where:</p> <ul> <li> <p><code>value</code> is the starting point on the dial.</p> </li> <li> <p><code>maximum_value</code> is the possible highest point on the dial.</p> </li> <li> <p><code>low_value</code> and <code>high_value</code> are the historical low and high values.</p> </li> </ul> <p>For example:</p> <pre xml:space="preserve" class="oac_no_warn"> SELECT dbms_random.value(500, 1200), 1300, dbms_random.value(100, 200) FROM DUAL </pre> <a id="sthref1132" name="sthref1132"></a> <p class="subhead2">Multiple Series<a id="sthref1133" name="sthref1133"></a><a id="sthref1134" name="sthref1134"></a> Syntax (Flash only)</p> <p>For column charts and line Flash charts, you can define multiple series in one SQL query. The series names for these chart types are derived from the corresponding column aliases in the query. To define a multiple series Flash chart, use the following syntax:</p> <pre xml:space="preserve" class="oac_no_warn"> SELECT link, label, series_1_value [, series_2_value [, ...]] FROM ... </pre> <a id="sthref1135" name="sthref1135"></a> <p class="subhead2">Range Chart <a id="sthref1136" name="sthref1136"></a><a id="sthref1137" name="sthref1137"></a>Syntax (Flash only)</p> <p>Range charts require two values for each bar. To create a range chart, create a Flash chart and provide a SQL query using the following syntax:</p> <pre xml:space="preserve" class="oac_no_warn"> SELECT link, label, low_value, high_value FROM ... </pre> <a id="sthref1138" name="sthref1138"></a> <p class="subhead2">Scatter Chart <a id="sthref1139" name="sthref1139"></a><a id="sthref1140" name="sthref1140"></a>Syntax (Flash only)</p> <p>Scatter charts require an <span class="italic">x</span> value and <span class="italic">y</span> value for each point. To create a range chart, create a Flash chart and provide a SQL query using the following syntax:</p> <pre xml:space="preserve" class="oac_no_warn"> SELECT link, label, x_value, y_value FROM ... </pre> <a id="sthref1141" name="sthref1141"></a> <p class="subhead2">Candlestick <a id="sthref1142" name="sthref1142"></a><a id="sthref1143" name="sthref1143"></a>Chart Syntax (Flash only)</p> <p>Candlestick charts require open, low, high, and close values for each candlestick. To create a candlestick chart, create a Flash chart and provide a SQL query using the following syntax:</p> <pre xml:space="preserve" class="oac_no_warn"> SELECT link, label, open, low, high, close FROM ... </pre></div> <!-- class="sect2" --> <!-- Start Footer --> <div class="footer"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr> <td align="left"><span class="copyrightlogo">Copyright © 2003, 2009, Oracle and/or its affiliates. All rights reserved.</span><br /> <a href="dcommon/html/cpyr.htm"><span class="copyrightlogo">Legal Notices</span></a></td> <td align="center"><a href="bldapp_chrt_type.htm"><img src="dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="bldapp_chrt_html.htm"><img src="dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </div> <!-- class="footer" --> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de