How to fix the Oracle error PLS-00358: column ‘string’ exists in more than one table; use qualifier?

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.