PLS-00428: an INTO clause is expected in this SELECT statement

PLS-00428: an INTO clause is expected in this SELECT statement
Cause: The INTO clause of a SELECT INTO statement was omitted. For example, the code might look like SELECT deptno, dname, loc FROM dept WHERE ... instead of SELECT deptno, dname, loc INTO dept_rec FROM dept WHERE ... In PL/SQL, only a subquery is written without an INTO clause.
Action: Add the required INTO clause.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00428：在这个SELECT语句中期望INTO子句,
.原因：省略了SELECT INTO语句的INTO子句。例如，代码可能看起来像SELECT deptno，dname，loc FROM dept WHERE ...而不是SELECT deptno，dname，loc INTO dept_rec FROM dept WHERE ...在PL / SQL中，只有一个子查询不会写入INTO子句。,
.操作：添加所需的INTO子句。,
.

aiaiDBA

13718043309

010-86462881

PLS-00428: an INTO clause is expected in this SELECT statement

1 个回答

相似问题