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


QSM-02150: select lists must be identical across the UNION
operator



QSM-02150: select lists must be identical across the UNION operator..

Answer / guest

Cause: You have specified a materialized view using the
UNION operator and the respective queries on each side of
the UNION operator do not have the same select list. The
RELATED_NAME column shows the alias of the first different
select list item. The RELATED_NUM column shows the offset
from the SELECT keyword to the start of this select list item.

Action: Restructure the materialized view query such that
the respective sides of the UNION operator have identical
select lists.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NNL-00575: list_objects: list all objects in a domain or subtree

1 Answers  


ORA-27093: could not delete directory

1 Answers  


SQL-02149: ANSI Dynamic insufficient item descriptor areas

1 Answers  


ORA-25187: specified exceptions table form incorrect

1 Answers  


ORA-31642: the following SQL statement fails: string

1 Answers  






ORA-29286: internal error

1 Answers  


PLS-01709: value list of INSERT statement, if specified with value list rather than subquery, must be value specification

1 Answers  


ORA-01683: unable to extend index string.string partition string by string in tablespace string

1 Answers  


ORA-02474: Fixed hash area extents used (string) exceeds maximum allowed (string)

1 Answers  


LSX-00163: duplicated content specification in "~S"

1 Answers  


RMAN-06581: option string not supported

1 Answers  


ORA-09271: szlon: error verifying user name

1 Answers  






Categories