重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: ORA-32042: recursive WITH clause must reference itself directly in one of the... [打印本页]

作者: michaeljet 时间: 2016-9-1 14:59
标题: ORA-32042: recursive WITH clause must reference itself directly in one of the...

Cause: A WITH clause query referredto itself (recursive) indirectly, such as

through a subquery or view.

Action: Rewrite the recursive WITHclause query to refer to itself directly in the

FROM clause of one of the UNION ALL branches.

欢迎光临重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)