ORA-32046: sequence column name for SEARCH clause must not be part of the column alias list

ORA-32046: sequence column name for SEARCH clause must not be part of the column alias list
Cause: The SEARCH clause for a recursive WITH query specified a sequence column that was already listed in the column alias list for the WITH clause query name.
Action: Specify a different name for the sequence column for the SEARCH clause or remove the name from the column alias list.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:49

ORA-32046：SEARCH子句的序列列名不能是列别名列表的一部分,
.原因：递归WITH查询的SEARCH子句指定已在WITH子句查询名称的列别名列表中列出的序列列。,
.操作：为SEARCH子句的序列列指定不同的名称，或者从列别名列表中删除名称。,
.

aiaiDBA

13718043309

010-86462881

ORA-32046: sequence column name for SEARCH clause must not be part of the column alias list

1 个回答

相似问题