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

ORA-23321: Pipename may not be null

1 Answers  


KUP-04071: record discarded from file string

1 Answers  


NID-00106: LOGIN to target database failed with Oracle error: string

1 Answers  


ORA-10570: Test recovery complete

1 Answers  


NNL-00004: invalid command argument "string"

1 Answers  






TNS-00026: INTCTL: TNS_ADMIN directory set, and is being used

1 Answers  


ORA-31096: validation failed for schema

1 Answers  


DRG-11817: Proxy Redirect

1 Answers  


NNL-00935: Requests refused, SINGLE-VALUE violation: number

1 Answers  


ORA-15185: Could not close dynamic library string, error [string]

1 Answers  


LPX-00250: invalid attribute declaration

1 Answers  


ORA-38445: TOP clause not allowed with no statistics

1 Answers  


Categories