2025年什么是Oracle数据库伪列,ORA-00976- 此处不允许指定的伪列或运算符

科技前沿 • 2025-03-25 07:02 • 阅读 51

大家好，我是讯享网，很高兴认识大家。

ORA-00976: 此处不允许指定的伪列或运算符

求指导，optimizer_features_enable 值已经修改尝试过了，没有效果

sql代码：

SELECT /*+ FIRST_ROWS(10) PARALLEL (XDS_DOCUMENT, 4) INDEX(XDS_DOCUMENT PK_XDS_ENTITY) */

XDS_DOCUMENT.REVISION,

XDS_DOCUMENT.DOCUMENT_ID,

XDS_DOCUMENT.NAME,

XDS_DOCUMENT.QUALIFIED_NAME,

XDS_DOCUMENT.DESCRIPTION,

XDS_DOCUMENT.CREATED_BY,

XDS_DOCUMENT.LASTMODIFIED_BY,

XDS_DOCUMENT.LASTMODIFIED_DATE,

XDS_DOCUMENT.CREATED_DATE,

XDS_DOCUMENT.ANNOTATION,

XDS_DOCUMENT.TYPE_ID,

XDS_DOCUMENT.TYPE_REVISION,

XDS_DOCUMENT.PARENT_ID,

XDS_DOCUMENT.OPTIMISTIC_LOCK,

XDS_DOCUMENT.ACCESSCONTROLPOLICY_ID,

XDS_DOCUMENT.INHERIT_PARENT_ACP,

XDS_DOCUMENT.STACK_LEVEL,

XDS_DOCUMENT.CONTENT

FROM XDS_DOCUMENT XDS_DOCUMENT

INNER JOIN (SELECT D2.DOCUMENT_ID, MAX(STACK_LEVEL) AS BLEVEL

FROM XDS_DOCUMENT D2

WHERE D2.REVISION IN

(SELECT REGISTERED_REVISION

FROM XDS_BRANCH

START WITH BRANCH_ID = 'E41F131E-A5FA-11E0-FF0B-4C0D519DB0F2'

CONNECT BY PRIOR PARENT_ID = BRANCH_ID)

AND D2.DOCUMENT_ID = 'E41F131E-A5FA-11E0-F8C5-E7D54B52D32B'

AND D2.TYPE_ID = 'ID_TYPE_XMLDOCUMENT'

GROUP BY D2.DOCUMENT_ID) SUB_RESULT

ON XDS_DOCUMENT.REVISION IN

(SELECT REGISTERED_REVISION

FROM XDS_BRANCH

START WITH BRANCH_ID = 'E41F131E-A5FA-11E0-FF0B-4C0D519DB0F2'

CONNECT BY PRIOR PARENT_ID = BRANCH_ID)

AND XDS_DOCUMENT.STACK_LEVEL = SUB_RESULT.BLEVEL

AND XDS_DOCUMENT.DOCUMENT_ID = SUB_RESULT.DOCUMENT_ID