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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    6 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-14274: partitions being merged are not adjacent

1 Answers  


PLS-00620: type mismatch found at 'string' among operands in a COALESCE expression

1 Answers  


ORA-00283: recovery session canceled due to errors

1 Answers  


ORA-12814: only one CACHE or NOCACHE clause may be specified

1 Answers  


ORA-07705: sksaprs: device name buffer too small

1 Answers  


ORA-21601: attribute is not an object

1 Answers  


ORA-26530: unable to build materialized view refresh control list

1 Answers  


ORA-16641: failure to acquire broker configuration metadata lock

1 Answers  


RMAN-06211: ==========================

1 Answers  


ORA-30938: No prefix defined for namespace 'string' (particle string)

1 Answers  


QSM-01086: dimension(s) not present or not used in ENFORCED integrity mode

1 Answers  


ORA-09827: SCLGT: atomic latch return unknown error.

1 Answers  


Categories