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 |
ORA-02361: error while attempting to allocate number bytes of memory
RMAN-06135: error executing host command: string
ORA-14117: partition resides in offlined tablespace
QSM-02134: agg(expr) requires correspondng MAX(expr) function
PLS-01413: Use of NULL an expression
ORA-16002: database already open for read-write access by another instance
ORA-13856: Service name must be specified
NNL-01051: Server name: string
ORA-25245: agent name cannot be specified if address is a single-consumer queue or an exception queue
ORA-01255: cannot shutdown - file string in recovery manager backup
LPX-00249: invalid external ID declaration
ORA-08413: invalid compiler type in FORMAT parameter at string