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


PLS-00119: Duplicate having-clause in table expression



PLS-00119: Duplicate having-clause in table expression..

Answer / guest

Cause: Two or more HAVING clauses were found in a SELECT
statement. The HAVING clause specifies a condition under
which groups of rows (formed by the GROUP BY clause) are
included in the result. The condition can include several
logical expressions connected by AND or OR, but a statement
can contain only one HAVING clause.

Action: Remove one of the HAVING clauses and, if necessary,
connect logical expressions by AND or OR.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-37103: (XSVPART03) The dimensionality or datatype of workspace object does not match the dimensionality or datatype of the partition.

1 Answers  


LFI-01001: Unable to write string bytes to file.

1 Answers  


ORA-24367: user handle has not been set in service handle

1 Answers  


RMAN-08097: channel string: starting validation of archive log backupset

1 Answers  


KUP-03020: empty delimiter specified for record

1 Answers  






TNS-00259: Disabled Interchange list:

1 Answers  


DRG-10313: logging has already been started

1 Answers  


ORA-38449: table "string" does not exist or is not accessible

1 Answers  


RMAN-20208: UNTIL CHANGE is before RESETLOGS change

1 Answers  


TNS-00042: INTCTL: CMANAGER already running. Start operation cancelled

1 Answers  


ORA-02210: no options specified for ALTER TABLE

1 Answers  


ORA-13005: recursive HHCODE function error

1 Answers  






Categories