Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

DRG-11213: CTXSYS does not own procedure filter stored procedure: string

1 Answers  


PLS-00310: with %%ROWTYPE attribute, 'string' must name a table, cursor or cursor-variable

1 Answers  


LPX-00259: invalid notation declaration

1 Answers  


QSM-02122: compatibility mode must be 8.1 or higher

1 Answers  


ORA-22338: must specify CASCADE INCLUDING DATA when altering the final property

1 Answers  






ORA-07747: slemrd: $READ failure

1 Answers  


NNO-00850: Error: LDAP query returns string

1 Answers  


TNS-12641: Authentication service failed to initialize

1 Answers  


PCC-00028: Option "string" not legal as EXEC ORACLE OPTION

1 Answers  


ORA-01575: timeout waiting for space management resource

1 Answers  


ORA-04017: invalid value string (length = string) for parameter max_dump_file_size

1 Answers  


NNL-00224: Scheduled statistic counters to be logged in string

1 Answers  






Categories