PLS-00119: Duplicate having-clause in table expression
- 1 Answers
- 3136 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-14021: MAXVALUE must be specified for all columns
ORA-29263: HTTP protocol error
ORA-12088: cannot online redefine table "string"."string" with unsupported datatype
PLS-00239: invalid external type specification for SQLCODE
ORA-29554: unhandled Java out of memory condition
ORA-22614: error while construction the collection in the image
ORA-16709: standby archived log location settings in conflict with flash recovery area
ORA-07404: sfareq: Timeout occurred waiting for request to complete.
NNO-00159: warning: ignoring duplicate hint domain number name "string"
ORA-07568: slspool: $OPEN failure
QSM-02091: mv references a non-repeatable or session-sensitive expression
ORA-19589: %s is not a snapshot or backup controlfile
Oracle Errors 
