1
select * from table connect by 产品=prior 组成产品明细 start with 产品='a'
2
需求不明确,e和f有区别吗,为什么只有f?
select * from table connect by 产品=prior 组成产品明细 start with 产品='a'
2
需求不明确,e和f有区别吗,为什么只有f?
解决方案 »
- 如何利用oracle的正则来分解XMLType类型的数据
- oracle中sql语言查询
- 请问物化视图的增量备份日志,跟我写个触发器记录备份那个快?
- start with...... connect by ......问题求解!
- oracle.sql.CLOB字段问题
- function中默认Boolean参数的问题
- 急!把子查询的结果当作某个列来显示该怎样做?
- 碰到个怪问题,明明表存在,但却不可见,也不可访问~~
- 怎樣啟動OMS
- ALTER DATABASE db1 CHARACTER SET WE8ISO8859P1
- oracle sql*plus 方向键不能用,怎么回事?
- oracle存储过程问题
is
nLoopCount NUMBER(10);CURSOR cOdrBasTbl1D
IS
SELECT * FROM (
select level,chd_itm_cd chd_itm_cd,PRT_ITM_CD
from prd_bom_tbl start with PRT_ITM_CD =itemname connect by prior chd_itm_cd = PRT_ITM_CD)
WHERE CHD_ITM_CD NOT IN (
SELECT PRT_ITM_CD FROM (
select level,chd_itm_cd chd_itm_cd,PRT_ITM_CD
from prd_bom_tbl start with PRT_ITM_CD =itemname connect by prior chd_itm_cd = PRT_ITM_CD ));
OdrBasTbl1D cOdrBasTbl1D%ROWTYPE;FOR OdrBasTbl1D IN cOdrBasTbl1D
LOOP
nLoopCount :=1;
FOR nLoopCount IN OdrBasTbl1D.LEVEL
LOOP
SELECT OdrBasTbl1D.chd_itm_cd chd_itm_cd into test FROM (
select level,chd_itm_cd chd_itm_cd,PRT_ITM_CD
from prd_bom_tbl start with chd_itm_cd =OdrBasTbl1D.chd_itm_cd connect by prior PRT_ITM_CD=chd_itm_cd )
WHERE PRT_ITM_CD NOT IN (
SELECT chd_itm_cd FROM (
select level,chd_itm_cd chd_itm_cd,PRT_ITM_CD
from prd_bom_tbl start with chd_itm_cd =OdrBasTbl1D.chd_itm_cd connect by prior PRT_ITM_CD=chd_itm_cd ))
GROUP BY OdrBasTbl1D.chd_itm_cd HAVING COUNT(*)=1;
nLoopCount:=nLoopCount+1;
END LOOP;
END LOOP;end;
上面的语法
FOR OdrBasTbl1D IN cOdrBasTbl1D这行提示出错,
pls-00103:出现符号"for"在需要下列之一时:begin function package pragma proceduresubtypetype use <an identifier>