PLS-00119: Duplicate having-clause in table expression
- 1 Answers
- 3020 Views
- I also Faced
- E-Mail Answers
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 |
ORA-16811: apply instance not recorded by the Data Guard broker
ORA-13854: Tracing for service(module/action) string on instance string is not enabled
ORA-16626: failed to enable specified object
ORA-600?
ORA-14171: cannot specify <subpartition-description> clause in CREATE|ALTER TABLE
ORA-32772: BIGFILE is invalid option for this type of tablespace
NZE-29039: There are no matching cipher suites.
RMAN-06131: skip offline/readonly only allowed with current controlfile
ORA-12404: invalid privilege string: string
NPL-00102: missing stream functions in ASN.1 context initialization
PCB-00304: Oracle extension to the WHENEVER statement
NNF-01004: DCE returned unspecified error string
Oracle Errors 
