PLS-00119: Duplicate having-clause in table expression
- 1 Answers
- 2342 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-37103: (XSVPART03) The dimensionality or datatype of workspace object does not match the dimensionality or datatype of the partition.
LFI-01001: Unable to write string bytes to file.
ORA-24367: user handle has not been set in service handle
RMAN-08097: channel string: starting validation of archive log backupset
KUP-03020: empty delimiter specified for record
TNS-00259: Disabled Interchange list:
DRG-10313: logging has already been started
ORA-38449: table "string" does not exist or is not accessible
RMAN-20208: UNTIL CHANGE is before RESETLOGS change
TNS-00042: INTCTL: CMANAGER already running. Start operation cancelled
ORA-02210: no options specified for ALTER TABLE
ORA-13005: recursive HHCODE function error
Oracle Errors 
