Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

ORA-01978: Missing sequence number

1 Answers  


ORA-16769: The physical standby database is incorrectly put into read-only state.

1 Answers  


ORA-14263: new subpartition name must differ from that of any other subpartition of the object

1 Answers  


ORA-28175: incorrect certificate type

1 Answers  


ORA-16635: NetSlave connection was broken in the middle of a transmission session.

1 Answers  


ORA-12513: TNS:service handler found but it has registered for a different protocol

1 Answers  


NNL-00539: start|startup [<args>] : start the Names server with optional arguments

1 Answers  


KUP-04091: little endian byte order mark found when big endian expected in string

1 Answers  


NZE-29176: CRL signature verification failed

1 Answers  


TNS-02524: Authentication: privilege check failed

1 Answers  


ORA-07703: error in archive text: need '/' after device type

1 Answers  


ORA-12334: database (link name string) is still open

1 Answers  


Categories