PLS-00119: Duplicate having-clause in table expression
- 1 Answers
- 2894 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 |
RMAN-08533: restoring blocks of datafile string
ORA-24361: basic bind call not invoked before invoking advanced bind call
ORA-12546: TNS:permission denied
PLS-00516: Type mismatch between object table and value 'string' in INSERT statement.
ORA-02057: 2PC: string: bad two-phase recovery state number string from string
ORA-01929: no privileges to GRANT
ORA-30748: column string already enabled to store objects of type string.string
ORA-22285: non-existent directory or file for string operation
ORA-32638: Non unique addressing in MODEL dimensions
ORA-15020: discovered duplicate ASM disk "string"
ORA-24010: QUEUE string does not exist
O2I-00115: Error opening the HFILE file
Oracle Errors 
