PLS-00119: Duplicate having-clause in table expression
- 1 Answers
- 2907 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-02435: cannot disable unique(string) - unique key not defined for table
ORA-12855: cannot run parallel or insert direct load in a loopback
SQL*Loader-00350: Syntax error at line number.
DRG-10602: failed to queue DML change to column string for primary key string
ORA-07276: no dba group in /etc/group.
ORA-31625: error changing username from string to string
ORA-19905: log_archive_format must contain %%s, %%t and %%r
ORA-32630: multiple assignment in automatic order MODEL
ORA-07475: slsget: cannot get vm statistics.
ORA-34363: (MXDSS13) number other user writing
RMAN-06463: Backup set key string cannot be backed up by proxy.
DRG-52102: an invalid transaction handle was passed to Oracle Text
Oracle Errors 
