PLS-00405: subquery not allowed in this context

PLS-00405: subquery not allowed in this context
Cause: A subquery was used in an inappropriate context, such as: if (SELECT deptno FROM emp WHERE ... ) = 20 then ... Subqueries are allowed only in SQL statements.
Action: The same result can be obtained by using a temporary variable, as in: SELECT deptno INTO temp_var FROM emp WHERE ...; IF temp_var = 20 THEN ...

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00405：在此上下文中不允许使用子查询,
.原因：在不合适的上下文中使用了一个子查询，例如：if（SELECT deptno FROM emp WHERE ...）= 20 then ...仅在SQL语句中允许子查询。,
.操作：通过使用临时变量可以获得相同的结果，如：SELECT deptno INTO temp_var FROM emp WHERE ...; IF temp_var = 20 THEN ...,
.

aiaiDBA

13718043309

010-86462881

PLS-00405: subquery not allowed in this context

1 个回答

相似问题