QSM-02090: SELECT includes an expression that is not just a
column



QSM-02090: SELECT includes an expression that is not just a column..

Answer / guest

Cause: The capability in question is not supported when the
materialized view uses an expression in the select list that
is not a simple column reference.

Action: Re-phrase the query to avoid the use of the
expressions that are not simple column references.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-32627: illegal pattern in MODEL FOR LIKE loop

1 Answers  


PLS-00642: local collection types not allowed in SQL statements

1 Answers  


PLS-00409: duplicate variable 'string' in INTO list is not permitted

1 Answers  


ORA-31476: a change table data column is missing from the source table

1 Answers  


ORA-30657: operation not supported on external organized table

2 Answers  






ORA-13291: conversion error between the specified unit and standard unit

1 Answers  


ORA-02772: Invalid maximum server idle time

1 Answers  


TNS-04071: Connections closed successfully. Number closed: number.

1 Answers  


IMG-00862: assert failure, inconsistency in merged area labels

1 Answers  


ORA-06250: NETNTT: cannot allocate send and receive buffers

1 Answers  


TNS-12158: TNS:could not initialize parameter subsystem

1 Answers  


ORA-16801: Some log transport related property is inconsistent.

1 Answers  


Categories