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

IMP-00032: SQL statement exceeded buffer length

1 Answers  


PLS-00496: too few columns in SELECT...INTO statement after bursting record targets

1 Answers  


PCC-01010: Invalid use of NULL character in character literal

1 Answers  


PLS-00503: RETURN <value> statement required for this return from function

1 Answers  


KUP-03003: absolute end(number) - start(number) != fieldlength (number) for field string

1 Answers  






ORA-33883: (MAKEDCL36) You cannot use the string attribute when you define an EXTERNAL partition with an existing target.

1 Answers  


ORA-26524: nls subsystem initialization failure for product=string, facility=string

1 Answers  


TNS-01203: Missing the account (string) specified by DEFAULT_USER_ACCOUNT in SID_DESC

1 Answers  


QSM-02017: subquery present in the HAVING clause

1 Answers  


ORA-00364: cannot write header to new log member

1 Answers  


LFI-00101: Write failed, file cannot be written to.

1 Answers  


ORA-06926: CMX: T_ERROR during read data

1 Answers  


Categories