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


PLS-00489: invalid table reference: 'string' must be a
column in this expression



PLS-00489: invalid table reference: 'string' must be a column in this expression..

Answer / guest

Cause: In a query, a select-list item refers to a table in
the FROM clause but not to a database column.

Action: Check the spelling of the column names, make sure
each column in the select list refers to a table in the FROM
clause, then re-execute the query.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

QSM-02028: group by CUBE

1 Answers  


ORA-01413: illegal value in packed decimal number buffer

1 Answers  


QSM-02115: mv references a remote object and is refreshed ON COMMIT

1 Answers  


TNS-00249: Unable to read network configuration data from file string with error: string

1 Answers  


ORA-13007: an invalid HEX character was detected

1 Answers  






EXP-00035: QUERY parameter valid only for table mode exports

1 Answers  


LCD-00203: missing keyword [string]

1 Answers  


ORA-02308: invalid option string for object type column

1 Answers  


ORA-36994: (XSRELGID11) The SURROGATE DIMENSION workspace object must be numeric.

1 Answers  


DRG-11206: user filter command string could not be executed

1 Answers  


ORA-24161: name string does not exist in the name value pair list

1 Answers  


NNL-00288: No cache flush currently scheduled

1 Answers  






Categories