PLS-00119: Duplicate having-clause in table expression
- 1 Answers
- 2914 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-35180: (SNSYN103) The format of the OUTFILE command is: OUTFILE [APPEND] {EOF | TRACEFILE | filename [NOCACHE] [NLS_CHARSET name]}
ORA-25106: only one of PARALLEL or NOPARALLEL clause may be specified
ORA-30201: Unable to load NLS data object
AMD-00137: prefix "string" exceeds maximum permitted length of string characters
DRG-11121: failed to read from file string
ORA-14106: LOGGING/NOLOGGING may not be specified for a clustered table
ORA-07710: sksaprs: file name buffer too small
ORA-39147: cannot migrate Data Pump queue table ownership to this instance
TNS-02515: Encryption/crypto-checksumming: unknown control type
IMG-00812: merged area queue initialization failed
ORA-24079: invalid name string, names with AQ$_ prefix are not valid for string
PROT-00012: Oracle Cluster Registry to be upgraded has an unsupported version
Oracle Errors 
