如下树查询代码:
SELECT DISTINCT
level,
sdf.classcode_no|| sdf.class_sign || sdf.fileabbr_no decimal_no,
sdf.file_name,
ss.struproject_name,
sdf.olddrawing_no,
sdf.file_version,
sdf.applier,
sdco.code_desc
from
STRU_DECIMAL_FILECODE sdf
LEFT JOIN
stru_struprojectinfo ss
ON
ss.struproject_id = sdf.struproject_id
LEFT JOIN
(select sdc.code,sdc.code_desc from stru_decimal_codeinfo sdc where code_type = 'FileCodeStatus') sdco
ON
sdco.code = sdf.status
start with
classcode_no|| class_sign ||fileabbr_no LIKE '%1%' and status <> '1' and re is null
connect by
class_sign = prior location and status <> '1' and re is null
ORDER SIBLINGS BY
level DESC;在oracle9i打了低版本的补丁中没出现错误,但在打了高版本补丁的机器中出现如下错误:ORA-00976: LEVEL, PRIOR, or ROWNUM not allowed here 请问大家是不是帮忙解决一下:是不是排序引起的问题,如果是,有没有办法解决,需要对level进行由大到小排
SELECT DISTINCT
level,
sdf.classcode_no|| sdf.class_sign || sdf.fileabbr_no decimal_no,
sdf.file_name,
ss.struproject_name,
sdf.olddrawing_no,
sdf.file_version,
sdf.applier,
sdco.code_desc
from
STRU_DECIMAL_FILECODE sdf
LEFT JOIN
stru_struprojectinfo ss
ON
ss.struproject_id = sdf.struproject_id
LEFT JOIN
(select sdc.code,sdc.code_desc from stru_decimal_codeinfo sdc where code_type = 'FileCodeStatus') sdco
ON
sdco.code = sdf.status
start with
classcode_no|| class_sign ||fileabbr_no LIKE '%1%' and status <> '1' and re is null
connect by
class_sign = prior location and status <> '1' and re is null
ORDER SIBLINGS BY
level DESC;在oracle9i打了低版本的补丁中没出现错误,但在打了高版本补丁的机器中出现如下错误:ORA-00976: LEVEL, PRIOR, or ROWNUM not allowed here 请问大家是不是帮忙解决一下:是不是排序引起的问题,如果是,有没有办法解决,需要对level进行由大到小排
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货