ORA-32482: sequence column for SEARCH clause must be different from the cycle mark column for CYCLE clause

ORA-32482: sequence column for SEARCH clause must be different from the cycle mark column for CYCLE clause
Cause: A SEARCH clause and a CYCLE clause was specified for a recursive WITH query, but the sequence column of the SEARCH clause matched the cycle mark column of the CYCLE clause.
Action: Change either the sequence column or the cycle mark column so that they no longer match.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:50

ORA-32482：SEARCH子句的序列列必须与CYCLE子句的循环标记列不同,
.原因：为递归WITH查询指定了SEARCH子句和CYCLE子句，但SEARCH子句的序列列与CYCLE子句的周期标记列匹配。,
.操作：更改序列列或循环标记列，以使它们不再匹配。,
.

aiaiDBA

13718043309

010-86462881

ORA-32482: sequence column for SEARCH clause must be different from the cycle mark column for CYCLE clause

1 个回答

相似问题