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

RMAN-06095: a backup controlfile must be restored to recover datafile string

1 Answers  


RMAN-06701: could not construct path for file: "string"

1 Answers  


RMAN-06105: duplicate qualifier found in LIST command: string

1 Answers  


ORA-02253: constraint specification not allowed here

3 Answers  


UDE-00002: invalid username or password

1 Answers  


IMP-00009: abnormal end of export file

1 Answers  


ORA-02454: Number of hash keys per block (string) exceeds maximum of string

1 Answers  


RMAN-06423: requested limit of number exceeds vendor limit of number

1 Answers  


ORA-00311: cannot read header from archived log

1 Answers  


ORA-15051: file 'string' contains string error(s)

1 Answers  


LSX-00292: value "~1S" is greater than maximum "~2S" (~3S)

1 Answers  


ORA-06511: PL/SQL: cursor already open

1 Answers  


Categories