代码语言
.
CSharp
.
JS
Java
Asp.Net
C
MSSQL
PHP
Css
PLSQL
Python
Shell
EBS
ASP
Perl
ObjC
VB.Net
VBS
MYSQL
GO
Delphi
AS
DB2
Domino
Rails
ActionScript
Scala
代码分类
文件
系统
字符串
数据库
网络相关
图形/GUI
多媒体
算法
游戏
Jquery
Extjs
Android
HTML5
菜单
网页交互
WinForm
控件
企业应用
安全与加密
脚本/批处理
开放平台
其它
【
PLSQL
】
求逐级向上汇总
作者:
Dezai.CN
/ 发布于
2011/8/3
/
836
<div> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">求逐级向上汇总</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-style: italic; font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(255,0,0); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">--公司信息表</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">CREATE</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">TABLE</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> TEST_COMPANYINFO</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">(</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">COMPID </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">VARCHAR2</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">(</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">30</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">), </span><span style="font-style: italic; font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(255,0,0); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">--公司</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">COMPNAME </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">VARCHAR2</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">(</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">200</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">), </span><span style="font-style: italic; font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(255,0,0); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">--公司名</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">PCOMPID </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">VARCHAR2</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">(</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">30</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">) </span><span style="font-style: italic; font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(255,0,0); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">--上级公司</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">);</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-style: italic; font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(255,0,0); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">--物品信息表</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">CREATE</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">TABLE</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> TEST_PRODUCTINFO</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">(</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">PRODID </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">VARCHAR2</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">(</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">20</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">), </span><span style="font-style: italic; font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(255,0,0); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">--物品</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">COMPID </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">VARCHAR2</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">(</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">30</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">), </span><span style="font-style: italic; font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(255,0,0); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">--公司</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">NUM</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">NUMBER</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">(</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">6</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">) </span><span style="font-style: italic; font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(255,0,0); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">--数量</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">);</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">INSERT</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">INTO</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> TEST_COMPANYINFO </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">VALUES</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> (</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'0100'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">,</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'可口可乐广东省公司'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">,</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">NULL</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">);</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">INSERT</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">INTO</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> TEST_COMPANYINFO </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">VALUES</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> (</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'0200'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">,</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'可口可乐深圳公司'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">,</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'0100'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">);</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">INSERT</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">INTO</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> TEST_COMPANYINFO </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">VALUES</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> (</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'0300'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">,</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'福田区可口可乐分公司'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">,</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'0200'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">);</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">INSERT</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">INTO</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> TEST_COMPANYINFO </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">VALUES</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> (</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'0301'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">,</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'南山区可口可乐分公司'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">,</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'0200'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">);</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">INSERT</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">INTO</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> TEST_COMPANYINFO </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">VALUES</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> (</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'0302'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">,</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'宝安区可口可乐分分公司'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">,</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'0200'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">);</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">INSERT</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">INTO</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> TEST_COMPANYINFO </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">VALUES</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> (</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'0210'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">,</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'可口可乐珠海公司'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">,</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'0100'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">);</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">INSERT</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">INTO</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> TEST_COMPANYINFO </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">VALUES</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> (</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'0320'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">,</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'吉大区可口可乐分公司'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">,</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'0210'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">);</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">INSERT</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">INTO</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> TEST_COMPANYINFO </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">VALUES</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> (</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'0330'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">,</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'香洲区可口可乐分公司'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">,</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'0210'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">);</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">INSERT</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">INTO</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> TEST_COMPANYINFO </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">VALUES</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> (</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'0340'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">,</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'拱北区可口可乐分分公司'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">,</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'0210'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">);</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">INSERT</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">INTO</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> TEST_PRODUCTINFO (PRODID, COMPID, </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">NUM</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">)</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">VALUES</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> (</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'1000001'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">, </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'0300'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">, </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">50</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">);</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">INSERT</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">INTO</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> TEST_PRODUCTINFO (PRODID, COMPID, </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">NUM</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">)</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">VALUES</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> (</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'1000001'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">, </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'0301'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">, </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">60</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">);</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">INSERT</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">INTO</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> TEST_PRODUCTINFO (PRODID, COMPID, </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">NUM</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">)</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">VALUES</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> (</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'1000001'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">, </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'0302'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">, </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">70</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">);</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">INSERT</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">INTO</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> TEST_PRODUCTINFO (PRODID, COMPID, </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">NUM</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">)</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">VALUES</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> (</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'1000002'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">, </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'0300'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">, </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">50</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">);</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">INSERT</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">INTO</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> TEST_PRODUCTINFO (PRODID, COMPID, </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">NUM</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">)</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">VALUES</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> (</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'1000002'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">, </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'0301'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">, </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">60</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">);</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">INSERT</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">INTO</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> TEST_PRODUCTINFO (PRODID, COMPID, </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">NUM</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">)</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">VALUES</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> (</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'1000002'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">, </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'0302'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">, </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">70</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">);</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">INSERT</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">INTO</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> TEST_PRODUCTINFO (PRODID, COMPID, </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">NUM</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">)</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">VALUES</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> (</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'1000002'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">, </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'0340'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">, </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">50</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">);</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">INSERT</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">INTO</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> TEST_PRODUCTINFO (PRODID, COMPID, </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">NUM</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">)</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">VALUES</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> (</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'1000001'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">, </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'0320'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">, </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">60</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">);</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">INSERT</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">INTO</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> TEST_PRODUCTINFO (PRODID, COMPID, </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">NUM</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">)</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">VALUES</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> (</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'1000003'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">, </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'0330'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">, </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">70</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">);</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">INSERT</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">INTO</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> TEST_PRODUCTINFO (PRODID, COMPID, </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">NUM</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">)</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">VALUES</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> (</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'1000003'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">, </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'0320'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">, </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">70</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">);</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">方法一、<span style="font-family: "Times New Roman"" face="Times New Roman">select t3.prodid,compid,t3.num,compname from</span></span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">(select sum(t2.num) num, prodid,pcompid from</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">(select t1.prodid,compid,t1.num,compname,c.pcompid from(select sum(t.num) num, prodid,pcompid from </span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">(select p.*,pcompid,compname from TEST_COMPANYINFO c,TEST_PRODUCTINFO p where c.compid=p.compid) t </span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">group by prodid,pcompid) t1,TEST_COMPANYINFO c where c.compid=t1.pcompid) t2 group by prodid,pcompid) t3,TEST_COMPANYINFO c </span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">where c.compid=t3.pcompid </span><span style="font-family: "宋体"; color: rgb(255,0,0); font-size: 10.5pt; mso-spacerun: 'yes'">--<span style="font-family: 宋体" face="宋体">省</span></span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">union </span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">(select t1.prodid,compid,t1.num,compname from(select sum(t.num) num, prodid,pcompid from </span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">(select p.*,pcompid,compname from TEST_COMPANYINFO c,TEST_PRODUCTINFO p where c.compid=p.compid) t </span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">group by prodid,pcompid) t1,TEST_COMPANYINFO c where c.compid=t1.pcompid)</span><span style="font-family: "宋体"; color: rgb(255,0,0); font-size: 10.5pt; mso-spacerun: 'yes'">--<span style="font-family: 宋体" face="宋体">市</span></span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">union </span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">(select p.*,compname from TEST_COMPANYINFO c,TEST_PRODUCTINFO p where c.compid=p.compid )</span><span style="font-family: "宋体"; color: rgb(255,0,0); font-size: 10.5pt; mso-spacerun: 'yes'">--<span style="font-family: 宋体" face="宋体">区</span></span><span style="font-family: "宋体"; color: rgb(255,0,0); font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; font-weight: normal; mso-spacerun: 'yes'">方法二、</span><span style="font-family: "宋体"; font-size: 10.5pt; font-weight: normal; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">with</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> t </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">as</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> (</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">select</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> compid,node</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">from</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> (</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">select</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> compid,</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">substr</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">(sub_node,</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">instr</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">(sub_node,</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'/'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">,</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">1</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">,</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">1</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">)+</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">1</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">,</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">instr</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">(sub_node,</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'/'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">,</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">1</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">,</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">2</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">) - </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">instr</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">(sub_node,</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'/'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">,</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">1</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">,</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">1</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">) -</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">1</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">) node</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">from</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> (</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">select</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> compid,sys_connect_by_path(compid,</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'/'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">)||</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">'/'</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> sub_node</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">from</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> test_companyinfo</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">connect</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">by</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> compid = </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">prior</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> pcompid</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">)</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">)</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">where</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> node </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">in</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> (</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">select</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">distinct</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> compid</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">from</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> test_companyinfo</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">where</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> connect_by_isleaf = </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">1</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">connect</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">by</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">prior</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> compid = pcompid</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">)</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">)</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">select</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> t.compid,(</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">select</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> compname </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">from</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> test_companyinfo </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">where</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> compid= t.compid) compname,</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">b.prodid,</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">sum</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">(b.num)</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">from</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> t,test_productinfo b</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">where</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> t.node = b.compid</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">group</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">by</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> t.compid,b.prodid</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">order</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">by</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> t.compid,b.prodid</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">具体参见图示：</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <img alt="" src="http://pic002.cnblogs.com/images/2011/304541/2011080216435228.png" /> <div style="layout-grid: 15.6pt none" class="Section0"> <div style="display: inline !important" class="Section0"> <p style="text-align: left; margin-top: 0pt; display: inline !important; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">方法三、树结构查询</span> </div> </div> <div style="layout-grid: 15.6pt none" class="Section0"> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">select</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> a.*,b.num ,</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">case</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">when</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">sum</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">(</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">num</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">) </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">over</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">(</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">partition</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">by</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> a.compid,compname,pcompid </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">order</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">by</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">null</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">) </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">is</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">null</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">then</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">sum</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">(</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">nvl</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">(</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">num</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">,</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">0</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">)) </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">over</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">(</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">partition</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">by</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">decode</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">(</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">level</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">,</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">2</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">,a.compid,pcompid) </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">order</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">by</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> a.compid </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">desc</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">) +</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">decode</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">(</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">level</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">,</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">1</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">,</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">sum</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">(</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">nvl</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">(</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">num</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">,</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">0</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">)) </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">over</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">(</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">partition</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">by</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">null</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">order</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">by</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">null</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">),</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,255); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">0</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">)</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">else</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">sum</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">(</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">num</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">) </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">over</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">(</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">partition</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">by</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> a.compid,compname,pcompid </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">order</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">by</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">null</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">)</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">end</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">from</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> TEST_COMPANYINFO a </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">left</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">join</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> TEST_PRODUCTINFO b </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">on</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> a.compid=b.compid</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">start</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">with</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> pcompid </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">is</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">null</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">CONNECT</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">BY</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> PCOMPID = </span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,128,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0">PRIOR</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"> a.COMPID</span><span style="font-family: "ËÎÌå"; background: rgb(192,192,192); color: rgb(0,0,128); font-size: 11pt; mso-spacerun: 'yes'; mso-highlight: #c0c0c0"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">方法四</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">、树状结构查询</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">WITH v_base_ma AS ( SELECT prodid pid, compid cid, SUM (num) ma</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">FROM TEST_PRODUCTINFO</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">GROUP BY prodid, compid</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">HAVING SUM (num) > 0),</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">v_comp</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">AS (SELECT DISTINCT COMPID cid, COMPNAME cname FROM TEST_COMPANYINFO),</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">v_prod AS (SELECT DISTINCT prodid pid FROM TEST_PRODUCTINFO),</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">OD AS ( </span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">SELECT COMPID,LEVEL LV</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">FROM TEST_COMPANYINFO</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">START WITH TRIM(PCOMPID) IS NULL</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">CONNECT BY PCOMPID = PRIOR COMPID)</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">SELECT A.*,LV</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">FROM (SELECT a.cid,</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">a.cname,</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">a.pid,</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">ma</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">FROM (SELECT a.cid,</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">a.cname,</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">b.pid,</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">(SELECT NVL (SUM (ma), 0) ma</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">FROM v_base_ma t</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">WHERE t.pid = b.pid</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">AND t.cid IN</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">( SELECT COMPID</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">FROM TEST_COMPANYINFO</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">START WITH PCOMPID = a.cid</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">CONNECT BY PCOMPID = PRIOR COMPID))</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">ma</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">FROM v_comp a, v_prod b) a</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">WHERE ma > 0</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">UNION ALL</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">SELECT l.cid,</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">cname,</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">pid,</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">ma</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">FROM v_base_ma l, v_comp e</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">WHERE l.cid = e.cid) A ,OD</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">WHERE CID=OD.COMPID</span><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'"><o:p></o:p></span> <p style="text-align: left; margin-top: 0pt; margin-bottom: 0pt" class="p0"><span style="font-family: "宋体"; font-size: 10.5pt; mso-spacerun: 'yes'">ORDER BY LV,cid, pid</span> </div> </div>
试试其它关键字
求逐级向上汇总
同语言下
.
查看某张表的表结构
.
oracle 集合操作
.
for 循环中倒序 用reverse
.
Oracle 临时表空间收缩
.
查看session及其对应运行的sql
.
Oracle常用查看表结构命令
.
Oracle Connect By Prior用法（实现递归查询）
.
重置排序 SEQUENCE
.
创建一个trigger
.
批量替换字段中的字符
可能有用的
.
C#实现的html内容截取
.
List 切割成几份 工具类
.
SQL查询 多列合并成一行用逗号隔开
.
一行一行读取txt的内容
.
C#动态修改文件夹名称(FSO实现，不移动文件)
.
c# 移动文件或文件夹
.
c#图片添加水印
.
Java PDF转换成图片并输出给前台展示
.
网站后台修改图片尺寸代码
.
处理大图片在缩略图时的展示
Dezai.CN
贡献的其它代码
(
4037
)
.
多线程Socket服务器模块
.
生成随机密码
.
清除浮动样式
.
弹出窗口居中
.
抓取url的函数
.
使用base HTTP验证
.
div模拟iframe嵌入效果
.
通过header转向的方法
.
Session操作类
.
执行sqlite输入插入操作后获得自动编号的ID
Copyright © 2004 - 2024 dezai.cn. All Rights Reserved
站长博客
粤ICP备13059550号-3