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


QSM-01060: illegal subquery in the HAVING clause



QSM-01060: illegal subquery in the HAVING clause..

Answer / guest

Cause: When a HAVING clause has a subquery, then any
references to the tables in the outer query should only
reference the tables in the GROUP BY clause.

Action: Correct error in the syntax and rerun the query.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-16081: insufficient number of processes for APPLY

1 Answers  


ORA-12040: master rollback segment option not support by master site string

1 Answers  


RMAN-06095: a backup controlfile must be restored to recover datafile string

1 Answers  


LSX-00234: invalid decimal "~S"

1 Answers  


PCC-00087: EXEC SQL TYPE statement not allowed for this host language

1 Answers  






ORA-30752: column or table string is not substitutable

1 Answers  


PLS-00714: supertypes's AUTHID is DEFINER but supertype and subtype are not in same schema

1 Answers  


ORA-36814: (XSTBLFUNC07) The datatype of the column used in the ROW2CELL clause of a LIMITMAP must be RAW(16).

1 Answers  


CLSS-00103: unable to read configuration information for node string

1 Answers  


ORA-07840: sllfop: LIB$GET_VM failure

1 Answers  


ORA-16216: Log stream sequence error

1 Answers  


ORA-24398: connection pool already exists

1 Answers  






Categories