PLS-00486: select list cannot be enclosed in parentheses

PLS-00486: select list cannot be enclosed in parentheses
Cause: In a SELECT statement, the select list was enclosed in parentheses, as in: SELECT (deptno, dname, loc) FROM dept INTO ... This breaks the rules of SQL syntax. Parentheses are not required because the keywords SELECT and FROM delimit the select list.
Action: Remove the parentheses enclosing the select list.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00486：选择列表不能括在括号中,
.原因：在SELECT语句中，选择列表包含在括号中，如下所示：SELECT（deptno，dname，loc）FROM dept INTO ...这打破了SQL语法的规则。括号不是必需的，因为关键字SELECT和FROM分隔选择列表。,
.操作：删除包围选择列表的括号。,
.

aiaiDBA

13718043309

010-86462881

PLS-00486: select list cannot be enclosed in parentheses

1 个回答

相似问题