取列数据的乘积代码,PLSQL代码库,德仔网

代码语言

代码分类

【PLSQL】取列数据的乘积

作者:Dezai.CN / 发布于2011/12/28/ 852

<div><span style="font-size: 8pt; ">---------------------------------------------------------------建表</span></div>
<div id="cnblogs_post_body"><span style="FONT-SIZE: 8pt">----------------判断表是否存在</span>
<span style="FONT-SIZE: 8pt">declare num number; </span>
<span style="FONT-SIZE: 8pt">begin </span>
<span style="FONT-SIZE: 8pt">    select  count(1) into num from user_tables where table_name='TEST';</span>
<span style="FONT-SIZE: 8pt">    if num>0 then </span>
<span style="FONT-SIZE: 8pt">      execute immediate 'drop table  TEST';</span>
<span style="FONT-SIZE: 8pt">    end if;</span>
<span style="FONT-SIZE: 8pt">end;</span>
<span style="FONT-SIZE: 8pt">----------------建表</span>
<span style="FONT-SIZE: 8pt">CREATE TABLE TEST(</span>
<span style="FONT-SIZE: 8pt">    ValueCol numeric</span>
<span style="FONT-SIZE: 8pt">);</span>
<span style="FONT-SIZE: 8pt">----------------第一部分测试数据</span>
<span style="FONT-SIZE: 8pt">INSERT INTO TEST VALUES(1); </span>
<span style="FONT-SIZE: 8pt">INSERT INTO TEST VALUES(2); </span>
<span style="FONT-SIZE: 8pt">INSERT INTO TEST VALUES(3); </span>
<span style="FONT-SIZE: 8pt">INSERT INTO TEST VALUES(4); </span>
<span style="FONT-SIZE: 8pt">INSERT INTO TEST VALUES(5); </span>
<span style="FONT-SIZE: 8pt">INSERT INTO TEST VALUES(6); </span>
<span style="FONT-SIZE: 8pt">COMMIT;</span>
<span style="FONT-SIZE: 8pt">--select *  from test;</span>
<span style="FONT-SIZE: 8pt">---------------------------------------------------------------行的乘积</span>
<span style="FONT-SIZE: 8pt">select exp(sum(ln(ValueCol))) from TEST;</span>
<span style="FONT-SIZE: 8pt">--------------- 删除实体</span>
<span style="FONT-SIZE: 8pt">DROP TABLE TEST;</span></div>
<script type="text/javascript"></script>

试试其它关键字

　取列数据的乘积　

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)