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-01413: illegal value in packed decimal number buffer
ORA-16169: LGWR network server invalid parameters
PCC-00086: Source file string has zero length
ORA-01236: Error string occurred during initialization of file header access
SQL*Loader-00808: error creating sequence: string
RMAN-06411: backup copies setting out of range (1-4): number
SQL*Loader-00264: File mode token string parsed but ignored
ORA-01183: cannot mount database in SHARED mode
ORA-23416: table "string"."string" does not contain a primary key constraint
ORA-13447: GeoRaster metadata BRS error
ORA-19648: datafile string: incremental-start SCN equals checkpoint SCN
ORA-32409: materialized view log on "string"."string" already excludes new values