九九乘法表代码,PLSQL代码库,德仔网

代码语言
代码分类
【PLSQL】九九乘法表
作者:Dezai.CN / 发布于2011/4/23/ 985
<div><span style="color: rgb(0,0,0)">SQL</span><span style="color: rgb(128,128,128)">></span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">with</span><span style="color: rgb(0,0,0)"> t </span><span style="color: rgb(0,0,255)">as</span><span style="color: rgb(0,0,0)"> (</span><span style="color: rgb(0,0,255)">select</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">level</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">as</span><span style="color: rgb(0,0,0)"> n </span><span style="color: rgb(0,0,255)">from</span><span style="color: rgb(0,0,0)"> dual connect </span><span style="color: rgb(0,0,255)">by</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">level</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)"><=</span><span style="color: rgb(128,0,0); font-weight: bold">9</span><span style="color: rgb(0,0,0)">)
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /> </span><span style="color: rgb(128,0,0); font-weight: bold">2</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">select</span><span style="color: rgb(0,0,0)"> sys_connect_by_path(b.n </span><span style="color: rgb(128,128,128)">||</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">*</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">||</span><span style="color: rgb(0,0,0)"> a.n </span><span style="color: rgb(128,128,128)">||</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">=</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">||</span><span style="color: rgb(0,0,0)"> a.n </span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(0,0,0)"> b.n, </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">) </span><span style="color: rgb(0,0,255)">as</span><span style="color: rgb(0,0,0)"> 九九乘法表
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /> </span><span style="color: rgb(128,0,0); font-weight: bold">3</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">from</span><span style="color: rgb(0,0,0)"> t a, t b
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /> </span><span style="color: rgb(128,0,0); font-weight: bold">4</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">where</span><span style="color: rgb(0,0,0)"> a.n </span><span style="color: rgb(128,128,128)">>=</span><span style="color: rgb(0,0,0)"> b.n </span><span style="color: rgb(128,128,128)">and</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">level</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)"> a.n
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /> </span><span style="color: rgb(128,0,0); font-weight: bold">5</span><span style="color: rgb(0,0,0)"> start </span><span style="color: rgb(0,0,255)">with</span><span style="color: rgb(0,0,0)"> b.n</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">1</span><span style="color: rgb(0,0,0)">
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /> </span><span style="color: rgb(128,0,0); font-weight: bold">6</span><span style="color: rgb(0,0,0)"> connect </span><span style="color: rgb(0,0,255)">by</span><span style="color: rgb(0,0,0)"> a.n</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)">prior a.n </span><span style="color: rgb(128,128,128)">and</span><span style="color: rgb(0,0,0)"> b.n</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(0,0,0)">prior b.n</span><span style="color: rgb(128,128,128)">+</span><span style="color: rgb(128,0,0); font-weight: bold">1</span><span style="color: rgb(0,0,0)">;
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" />
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" />九九乘法表
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /></span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)">------------------------------------------------------------------------------</span><span style="color: rgb(0,128,128)">
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /></span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">1</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">1</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">1</span><span style="color: rgb(0,0,0)">
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /> </span><span style="color: rgb(128,0,0); font-weight: bold">1</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">2</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">2</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">2</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">2</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">4</span><span style="color: rgb(0,0,0)">
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /> </span><span style="color: rgb(128,0,0); font-weight: bold">1</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">3</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">3</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">2</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">3</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">6</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">3</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">3</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">9</span><span style="color: rgb(0,0,0)">
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /> </span><span style="color: rgb(128,0,0); font-weight: bold">1</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">4</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">4</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">2</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">4</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">8</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">3</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">4</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">12</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">4</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">4</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">16</span><span style="color: rgb(0,0,0)">
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /> </span><span style="color: rgb(128,0,0); font-weight: bold">1</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">5</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">5</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">2</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">5</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">10</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">3</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">5</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">15</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">4</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">5</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">20</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">5</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">5</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">25</span><span style="color: rgb(0,0,0)">
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /> </span><span style="color: rgb(128,0,0); font-weight: bold">1</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">6</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">6</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">2</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">6</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">12</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">3</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">6</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">18</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">4</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">6</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">24</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">5</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">6</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">30</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">6</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">6</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">36</span><span style="color: rgb(0,0,0)">
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /> </span><span style="color: rgb(128,0,0); font-weight: bold">1</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">7</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">7</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">2</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">7</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">14</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">3</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">7</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">21</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">4</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">7</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">28</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">5</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">7</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">35</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">6</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">7</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">42</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">7</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">7</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">49</span><span style="color: rgb(0,0,0)">
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /> </span><span style="color: rgb(128,0,0); font-weight: bold">1</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">8</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">8</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">2</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">8</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">16</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">3</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">8</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">24</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">4</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">8</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">32</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">5</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">8</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">40</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">6</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">8</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">48</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">7</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">8</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">56</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">8</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">8</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">64</span><span style="color: rgb(0,0,0)">
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /> </span><span style="color: rgb(128,0,0); font-weight: bold">1</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">9</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">9</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">2</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">9</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">18</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">3</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">9</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">27</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">4</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">9</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">36</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">5</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">9</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">45</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">6</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">9</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">54</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">7</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">9</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">63</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">8</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">9</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">72</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">9</span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(128,0,0); font-weight: bold">9</span><span style="color: rgb(128,128,128)">=</span><span style="color: rgb(128,0,0); font-weight: bold">81</span><span style="color: rgb(0,0,0)">
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" />
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /></span><span style="color: rgb(128,0,0); font-weight: bold">9</span><span style="color: rgb(0,0,0)"> rows selected
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" />
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" />SQL</span><span style="color: rgb(128,128,128)">></span><span style="color: rgb(0,0,0)"> 
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /></span></div>
试试其它关键字
　九九乘法表　
同语言下
可能有用的
Dezai.CN贡献的其它代码(4037)