ORA-02345: cannot create a view with column based on CURSOR operator

ORA-02345: cannot create a view with column based on CURSOR operator
Cause: A CURSOR operator was used as one of the SELECT elements in the subquery of a CREATE VIEW or CREATE TABLE ... AS SELECT statement.
Action: Remove the CURSOR operator and replace it with the CAST operator.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:37

ORA-02345：无法使用基于CURSOR运算符的列创建视图,
.原因： CURSOR运算符用作CREATE VIEW或CREATE TABLE ... AS SELECT语句的子查询中的SELECT元素之一。,
.操作：删除CURSOR运算符，并将其替换为CAST运算符。,
.

aiaiDBA

13718043309

010-86462881

ORA-02345: cannot create a view with column based on CURSOR operator

1 个回答

相似问题