PLS-00358: column 'string' exists in more than one table; use qualifier

PLS-00358: column 'string' exists in more than one table; use qualifier
Cause: The statement is ambiguous because it specifies two or more tables having the same column name. For example, the following statement is ambiguous because deptno is a column in both tables: SELECT deptno, loc INTO my_deptno, my_loc FROM emp, dept;
Action: Precede the column name with the table name (as in emp.deptno) so that the column reference is unambiguous.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00358：列' string '存在于多个表中; 使用限定词,
.原因：该语句是不明确的，因为它指定了两个或多个具有相同列名称的表。例如，以下语句是不明确的，因为deptno是两个表中的列：SELECT deptno，loc INTO my_deptno，my_loc FROM emp，dept;,
.操作：使用表名称（如emp.deptno中）列出列名，以便列引用是明确的。,
.

aiaiDBA

13718043309

010-86462881

PLS-00358: column 'string' exists in more than one table; use qualifier

1 个回答

相似问题