QSM-02017: subquery present in the HAVING clause



QSM-02017: subquery present in the HAVING clause..

Answer / guest

Cause: The capability in question is not supported when the
materialized view uses a subquery in the HAVING clause.

Action: Re-phrase the query to avoid the subquery in the
HAVING clause.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-25115: duplicate BLOCK option specification

1 Answers  


ORA-17626: ksfdcre: string file exists

1 Answers  


ORA-39133: object type "string"."string" already exists with different typeid

1 Answers  


ORA-07493: scgrcl: lock manager error.

1 Answers  


LPX-00204: syntax error

1 Answers  






ORA-06112: NETTCP: invalid buffer size

1 Answers  


ORA-27010: skgfwrt: write to file failed

1 Answers  


ORA-13366: invalid combination of interior exterior rings

1 Answers  


IMG-00603: unable to access source image data

1 Answers  


ORA-24180: invalid transformation expression, the transformation expression does not evaluate to the target type/attribute

1 Answers  


ORA-19624: operation failed, retry possible

2 Answers  


SQL-02156: Invalid type for Indicator or Returned Length

1 Answers  


Categories