邪恶八进制信息安全团队技术讨论组 » 常用数据库类{ Database Security } » 巨人脚下[ Oracle ] » [转载]10g中如何构造柱状图? [查看完整版本]

ring04h 2006-6-15 23:42

[转载]10g中如何构造柱状图?

<p>信息来源: it168</p><div><div style="TEXT-INDENT: 18pt"><span style="FONT-SIZE: 9pt">在10gR1开始,oracle就允许用户自己构造柱状图,由于柱状图分等高与等宽两种,所以由width_bucket构造等宽柱状图,由ntile构造等高的柱状图,测试方法如下所示:</span></div><span style="FONT-SIZE: 9pt"> 创建表</span><span style="FONT-SIZE: 9pt">: </span></div><div style="SCROLLBAR-HIGHLIGHT-COLOR: buttonhighlight; OVERFLOW: auto; WIDTH: 500px"><pre style="BORDER-RIGHT: black 1px solid; PADDING-RIGHT: 4px; BORDER-TOP: black 1px solid; PADDING-LEFT: 4px; PADDING-BOTTOM: 4px; BORDER-LEFT: black 1px solid; PADDING-TOP: 4px; BORDER-BOTTOM: black 1px solid; BACKGROUND-COLOR: #ededed"><div id="2">
<div><!--
Code highlighting produced by Actipro CodeHighlighter (freeware)
[url]http://www.CodeHighlighter.com/[/url]
--><img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" /><span style="COLOR: #0000ff">create</span><span style="COLOR: #000000"></span><span style="COLOR: #0000ff">table</span><span style="COLOR: #000000"> test_0211 </span><span style="COLOR: #0000ff">as</span><span style="COLOR: #000000"></span><span style="COLOR: #0000ff">select</span><span style="COLOR: #000000"></span><span style="COLOR: #808080">*</span><span style="COLOR: #000000"></span><span style="COLOR: #0000ff">from</span><span style="COLOR: #000000"> dba_objects;</span></div>
</div></pre></div><div id="3"><span style="FONT-SIZE: 9pt"></span><span style="FONT-SIZE: 9pt">分析并产生柱状图</span><span style="FONT-SIZE: 9pt">: </span></div><div style="SCROLLBAR-HIGHLIGHT-COLOR: buttonhighlight; OVERFLOW: auto; WIDTH: 500px"><pre style="BORDER-RIGHT: black 1px solid; PADDING-RIGHT: 4px; BORDER-TOP: black 1px solid; PADDING-LEFT: 4px; PADDING-BOTTOM: 4px; BORDER-LEFT: black 1px solid; PADDING-TOP: 4px; BORDER-BOTTOM: black 1px solid; BACKGROUND-COLOR: #ededed"><div id="4">
<div><!--
Code highlighting produced by Actipro CodeHighlighter (freeware)
[url]http://www.CodeHighlighter.com/[/url]
--><img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" /><span style="COLOR: #000000">analyze </span><span style="COLOR: #0000ff">table</span><span style="COLOR: #000000"> test_0211 </span><span style="COLOR: #0000ff">compute</span><span style="COLOR: #000000"></span><span style="COLOR: #0000ff">statistics</span><span style="COLOR: #000000"></span><span style="COLOR: #0000ff">for</span><span style="COLOR: #000000"></span><span style="COLOR: #0000ff">table</span><span style="COLOR: #000000"></span><span style="COLOR: #0000ff">for</span><span style="COLOR: #000000"></span><span style="COLOR: #808080">all</span><span style="COLOR: #000000"> columns size </span><span style="FONT-WEIGHT: bold; COLOR: #800000">18</span><span style="COLOR: #000000">;</span></div>
</div></pre></div><div id="5"><span style="FONT-SIZE: 9pt">查看已经产生的柱状图</span><span style="FONT-SIZE: 9pt">: </span></div><div style="SCROLLBAR-HIGHLIGHT-COLOR: buttonhighlight; OVERFLOW: auto; WIDTH: 500px"><pre style="BORDER-RIGHT: black 1px solid; PADDING-RIGHT: 4px; BORDER-TOP: black 1px solid; PADDING-LEFT: 4px; PADDING-BOTTOM: 4px; BORDER-LEFT: black 1px solid; PADDING-TOP: 4px; BORDER-BOTTOM: black 1px solid; BACKGROUND-COLOR: #ededed"><div id="6">
<div><!--
Code highlighting produced by Actipro CodeHighlighter (freeware)
[url]http://www.CodeHighlighter.com/[/url]
--><img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" /><span style="COLOR: #000000">SQL</span><span style="COLOR: #808080">></span><span style="COLOR: #000000"> col endpoint_value format </span><span style="FONT-WEIGHT: bold; COLOR: #800000">999999</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />SQL</span><span style="COLOR: #808080">></span><span style="COLOR: #000000"> col column_name format a18
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />SQL</span><span style="COLOR: #808080">></span><span style="COLOR: #0000ff">select</span><span style="COLOR: #000000"> table_name, column_name, endpoint_number, endpoint_value
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: #0000ff">from</span><span style="COLOR: #000000"> user_histograms
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: #0000ff">where</span><span style="COLOR: #000000"> table_name </span><span style="COLOR: #808080">=</span><span style="COLOR: #000000"></span><span style="COLOR: #ff0000">'</span><span style="COLOR: #ff0000">TEST_0211</span><span style="COLOR: #ff0000">'</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: #808080">and</span><span style="COLOR: #000000"> column_name </span><span style="COLOR: #808080">=</span><span style="COLOR: #000000"></span><span style="COLOR: #ff0000">'</span><span style="COLOR: #ff0000">OBJECT_ID</span><span style="COLOR: #ff0000">'</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />TABLE_NAME COLUMN_NAME ENDPOINT_NUMBER ENDPOINT_VALUE
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: #008080">--</span><span style="COLOR: #008080">------------ ---------------------------- --------------</span><span style="COLOR: #008080">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: #000000">TEST_0211 </span><span style="COLOR: #ff00ff">OBJECT_ID</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">0</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">2</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />TEST_0211 </span><span style="COLOR: #ff00ff">OBJECT_ID</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">1</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">583</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />TEST_0211 </span><span style="COLOR: #ff00ff">OBJECT_ID</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">2</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">1150</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />TEST_0211 </span><span style="COLOR: #ff00ff">OBJECT_ID</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">3</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">1702</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />TEST_0211 </span><span style="COLOR: #ff00ff">OBJECT_ID</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">4</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">2254</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />TEST_0211 </span><span style="COLOR: #ff00ff">OBJECT_ID</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">5</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">2806</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />TEST_0211 </span><span style="COLOR: #ff00ff">OBJECT_ID</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">6</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">3358</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />TEST_0211 </span><span style="COLOR: #ff00ff">OBJECT_ID</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">7</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">3920</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />TEST_0211 </span><span style="COLOR: #ff00ff">OBJECT_ID</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">8</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">4477</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />TEST_0211 </span><span style="COLOR: #ff00ff">OBJECT_ID</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">9</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">5051</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />TEST_0211 </span><span style="COLOR: #ff00ff">OBJECT_ID</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">10</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">5611</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />TEST_0211 </span><span style="COLOR: #ff00ff">OBJECT_ID</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">11</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">6264</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />TEST_0211 </span><span style="COLOR: #ff00ff">OBJECT_ID</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">12</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">6816</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />TEST_0211 </span><span style="COLOR: #ff00ff">OBJECT_ID</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">13</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">7387</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />TEST_0211 </span><span style="COLOR: #ff00ff">OBJECT_ID</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">14</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">7949</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />TEST_0211 </span><span style="COLOR: #ff00ff">OBJECT_ID</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">15</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">8508</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />TEST_0211 </span><span style="COLOR: #ff00ff">OBJECT_ID</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">16</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">9093</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />TEST_0211 </span><span style="COLOR: #ff00ff">OBJECT_ID</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">17</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">9724</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />TEST_0211 </span><span style="COLOR: #ff00ff">OBJECT_ID</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">18</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">10438</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" /></span></div>
</div></pre></div><div id="7"><span style="FONT-SIZE: 9pt">通过运算</span><span style="FONT-SIZE: 9pt">,</span><span style="FONT-SIZE: 9pt">可以得知每个</span><span style="FONT-SIZE: 9pt">bucket</span><span style="FONT-SIZE: 9pt">大约会有</span><span style="FONT-SIZE: 9pt">551</span><span style="FONT-SIZE: 9pt">个成员 </span><span style="FONT-SIZE: 9pt"> 以下是由</span><span style="FONT-SIZE: 9pt">width_bucket</span><span style="FONT-SIZE: 9pt">函数构造的柱状图</span><span style="FONT-SIZE: 9pt">: </span><br /></div><div style="SCROLLBAR-HIGHLIGHT-COLOR: buttonhighlight; OVERFLOW: auto; WIDTH: 500px"><pre style="BORDER-RIGHT: black 1px solid; PADDING-RIGHT: 4px; BORDER-TOP: black 1px solid; PADDING-LEFT: 4px; PADDING-BOTTOM: 4px; BORDER-LEFT: black 1px solid; PADDING-TOP: 4px; BORDER-BOTTOM: black 1px solid; BACKGROUND-COLOR: #ededed"><div id="8">
<div><!--
Code highlighting produced by Actipro CodeHighlighter (freeware)
[url]http://www.CodeHighlighter.com/[/url]
--><img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" /><span style="COLOR: #000000">SQL</span><span style="COLOR: #808080">></span><span style="COLOR: #000000"></span><span style="COLOR: #0000ff">select</span><span style="COLOR: #000000"></span><span style="COLOR: #ff00ff">count</span><span style="COLOR: #000000">(</span><span style="COLOR: #808080">*</span><span style="COLOR: #000000">) </span><span style="COLOR: #0000ff">from</span><span style="COLOR: #000000"> test_0211;
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: #ff00ff">COUNT</span><span style="COLOR: #000000">(</span><span style="COLOR: #808080">*</span><span style="COLOR: #000000">)
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: #008080">--</span><span style="COLOR: #008080">--------</span><span style="COLOR: #008080">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="FONT-WEIGHT: bold; COLOR: #800000">9924</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />SQL</span><span style="COLOR: #808080">></span><span style="COLOR: #000000"></span><span style="COLOR: #0000ff">select</span><span style="COLOR: #000000"></span><span style="COLOR: #ff00ff">floor</span><span style="COLOR: #000000">(</span><span style="FONT-WEIGHT: bold; COLOR: #800000">9924</span><span style="COLOR: #808080">/</span><span style="FONT-WEIGHT: bold; COLOR: #800000">18</span><span style="COLOR: #000000">) </span><span style="COLOR: #0000ff">from</span><span style="COLOR: #000000"> dual;
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: #ff00ff">FLOOR</span><span style="COLOR: #000000">(</span><span style="FONT-WEIGHT: bold; COLOR: #800000">9924</span><span style="COLOR: #808080">/</span><span style="FONT-WEIGHT: bold; COLOR: #800000">18</span><span style="COLOR: #000000">)
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: #008080">--</span><span style="COLOR: #008080">------------</span><span style="COLOR: #008080">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="FONT-WEIGHT: bold; COLOR: #800000">551</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" /></span></div>
</div></pre></div><div id="9"></div><div style="SCROLLBAR-HIGHLIGHT-COLOR: buttonhighlight; OVERFLOW: auto; WIDTH: 500px"><pre style="BORDER-RIGHT: black 1px solid; PADDING-RIGHT: 4px; BORDER-TOP: black 1px solid; PADDING-LEFT: 4px; PADDING-BOTTOM: 4px; BORDER-LEFT: black 1px solid; PADDING-TOP: 4px; BORDER-BOTTOM: black 1px solid; BACKGROUND-COLOR: #ededed"><div id="10">
<div><!--
Code highlighting produced by Actipro CodeHighlighter (freeware)
[url]http://www.CodeHighlighter.com/[/url]
--><img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" /><span style="COLOR: #0000ff">select</span><span style="COLOR: #000000"></span><span style="COLOR: #0000ff">distinct</span><span style="COLOR: #000000"> table_name,
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />column_name,
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />endpoint_number,
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: #ff00ff">max</span><span style="COLOR: #000000">(</span><span style="COLOR: #ff00ff">object_id</span><span style="COLOR: #000000">) </span><span style="COLOR: #0000ff">over</span><span style="COLOR: #000000">(partition </span><span style="COLOR: #0000ff">by</span><span style="COLOR: #000000"> endpoint_number) </span><span style="COLOR: #0000ff">as</span><span style="COLOR: #000000"> endpoint_number
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: #0000ff">from</span><span style="COLOR: #000000"> (</span><span style="COLOR: #0000ff">SELECT</span><span style="COLOR: #000000"></span><span style="COLOR: #ff0000">'</span><span style="COLOR: #ff0000">TEST_0211</span><span style="COLOR: #ff0000">'</span><span style="COLOR: #000000"> table_name,
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: #ff0000">'</span><span style="COLOR: #ff0000">OBJECT_ID</span><span style="COLOR: #ff0000">'</span><span style="COLOR: #000000"> column_name,
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: #ff00ff">object_id</span><span style="COLOR: #000000">,
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />WIDTH_BUCKET(</span><span style="COLOR: #ff00ff">object_id</span><span style="COLOR: #000000">, </span><span style="FONT-WEIGHT: bold; COLOR: #800000">0</span><span style="COLOR: #000000">, </span><span style="FONT-WEIGHT: bold; COLOR: #800000">9924</span><span style="COLOR: #000000">, </span><span style="FONT-WEIGHT: bold; COLOR: #800000">18</span><span style="COLOR: #000000">) ENDpoint_number
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: #0000ff">FROM</span><span style="COLOR: #000000"> test_0211) a
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: #0000ff">order</span><span style="COLOR: #000000"></span><span style="COLOR: #0000ff">by</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">3</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />TABLE_NAM COLUMN_NAME ENDPOINT_NUMBER ENDPOINT_NUMBER
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: #008080">--</span><span style="COLOR: #008080">------- ------------------ --------------- ---------------</span><span style="COLOR: #008080">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: #000000">TEST_0211 </span><span style="COLOR: #ff00ff">OBJECT_ID</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">1</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">551</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />TEST_0211 </span><span style="COLOR: #ff00ff">OBJECT_ID</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">2</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">1102</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />TEST_0211 </span><span style="COLOR: #ff00ff">OBJECT_ID</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">3</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">1653</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />TEST_0211 </span><span style="COLOR: #ff00ff">OBJECT_ID</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">4</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">2205</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />TEST_0211 </span><span style="COLOR: #ff00ff">OBJECT_ID</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">5</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">2756</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />TEST_0211 </span><span style="COLOR: #ff00ff">OBJECT_ID</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">6</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">3307</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />TEST_0211 </span><span style="COLOR: #ff00ff">OBJECT_ID</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">7</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">3859</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />TEST_0211 </span><span style="COLOR: #ff00ff">OBJECT_ID</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">8</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">4410</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />TEST_0211 </span><span style="COLOR: #ff00ff">OBJECT_ID</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">9</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">4961</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />TEST_0211 </span><span style="COLOR: #ff00ff">OBJECT_ID</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">10</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">5513</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />TEST_0211 </span><span style="COLOR: #ff00ff">OBJECT_ID</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">11</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">6064</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />TEST_0211 </span><span style="COLOR: #ff00ff">OBJECT_ID</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">12</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">6615</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />TEST_0211 </span><span style="COLOR: #ff00ff">OBJECT_ID</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">13</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">7167</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />TEST_0211 </span><span style="COLOR: #ff00ff">OBJECT_ID</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">14</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">7718</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />TEST_0211 </span><span style="COLOR: #ff00ff">OBJECT_ID</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">15</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">8269</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />TEST_0211 </span><span style="COLOR: #ff00ff">OBJECT_ID</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">16</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">8821</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />TEST_0211 </span><span style="COLOR: #ff00ff">OBJECT_ID</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">17</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">9372</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />TEST_0211 </span><span style="COLOR: #ff00ff">OBJECT_ID</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">18</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">9923</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" />TEST_0211 </span><span style="COLOR: #ff00ff">OBJECT_ID</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">19</span><span style="COLOR: #000000"></span><span style="FONT-WEIGHT: bold; COLOR: #800000">10438</span><span style="COLOR: #000000">
<img src="http://cms.it168.com/Images/OutliningIndicators/None.gif" align="top" /></span></div>
</div></pre></div><p></p>

查看完整版本: [转载]10g中如何构造柱状图?

© 1999-2008 EvilOctal Security Team