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


QSM-02142: COUNT(*) is not present in the select list



QSM-02142: COUNT(*) is not present in the select list..

Answer / guest

Cause: The materialized view query omits COUNT(*) from the
select list.

Action: Add COUNT(*) to the select list.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NID-00308: Control File string - dbid changed

1 Answers  


ORA-19606: Cannot copy or restore to snapshot controlfile

1 Answers  


ORA-00164: distributed autonomous transaction disallowed within migratable distributed transaction

1 Answers  


EXP-00018: datatype (number) for column string, table string.string is not supported

1 Answers  


RMAN-08099: specifying standby controlfile for proxy backup

1 Answers  






ORA-24779: detach not allowed with open remote cursor

1 Answers  


RMAN-11006: WARNING: test recovery results: string

1 Answers  


ORA-15058: disk 'string' belongs to an incompatible diskgroup

1 Answers  


PCC-02372: FOR clause not allowed in SELECT statement

1 Answers  


ORA-24357: internal error while converting from to OCIDate.

1 Answers  


LSX-00310: local element or attribute should be namespace qualified

1 Answers  


ORA-09700: sclin: maximum number of latches exceeded

1 Answers  






Categories