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

O2F-00315: An attribute of a type is listed twice in a type specification

1 Answers  


PLS-01422: Aliases

1 Answers  


NNC-00004: connection is broken

1 Answers  


TNS-12593: TNS:no registered connection

1 Answers  


CLSS-03001: local node number string, master node number string

1 Answers  






PLS-00232: nested packages not permitted

2 Answers  


ORA-31041: Property string: Memory type (string) not compatible with database type (string)

1 Answers  


NNO-00631: warning: forwarder number has invalid name "string", forwarder ignored

1 Answers  


ORA-13851: Tracing for client identifier string is already enabled

1 Answers  


PCC-02316: illegal operator in constant expression

1 Answers  


ORA-01661: tablespace 'string' is already temporary

1 Answers  


ORA-28003: password verification for the specified password failed

1 Answers  


Categories