ORA-32048: cycle mark column name for CYCLE clause must not be part of the column alias list

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

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:49

ORA-32048：CYCLE子句的循环标记列名称不能是列别名列表的一部分,
.原因：递归WITH查询的CYCLE子句指定了已在WITH子句查询名称的列别名列表中列出的循环标记列。,
.操作：为CYCLE子句的循环标记列指定不同的名称，或从列别名列表中删除名称。,
.

aiaiDBA

13718043309

010-86462881

ORA-32048: cycle mark column name for CYCLE clause must not be part of the column alias list

1 个回答

相似问题