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

标题: ORA-29921: Ancillary operator not supported [打印本页]

作者: admin    时间: 2016-9-4 18:43
标题: ORA-29921: Ancillary operator not supported
ORA-29921: Ancillary operator not supported with set view query block
Cause:
Outer view queryblock contains ancillary operator and view query block
contains union all.
Action: Define the union-allview query to contain the primary and ancillary
query terms. i.e. have the operators within the view definition rather than inthe
query outside the view.







欢迎光临 重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/) Powered by Discuz! X3.2