Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-14046: a partition may be split into exactly two new partitions

1 Answers  


ORA-16952: Failed to bind this SQL statement.

1 Answers  


ORA-25175: no PRIMARY KEY constraint found

1 Answers  


DRG-11707: valid relations: string

1 Answers  


ORA-22608: cannot add an attribute to the already generated image handle

1 Answers  






ORA-22304: input type is not an object type

1 Answers  


LFI-00115: Buffer free failed.

1 Answers  


RMAN-00554: initialization of internal recovery manager package failed

1 Answers  


ORA-12223: TNS:internal limit restriction exceeded

1 Answers  


ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

3 Answers  


ORA-06548: no more rows needed

1 Answers  


ORA-12571: TNS:packet writer failure

1 Answers  






Categories