In this post, you’ll learn more about the Oracle ErrorPLS-00358: column ‘string’ exists in more than one table; use qualifier with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
PLS-00358: column ‘string’ exists in more than one table; use qualifier
Reason for the Error PLS-00358: column ‘string’ exists in more than one table; use qualifier
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;
How to fix the Error PLS-00358: column ‘string’ exists in more than one table; use qualifier ?
You can fix this error in Oracle by following the below steps
Precede the column name with the table name (as in emp.deptno) so that the column reference is unambiguous.