PLS-01471: The keyword DISTINCT must be present in a COUNT(DISTINCT sim

PLS-01471: The keyword DISTINCT must be present in a
COUNT(DISTINCT sim_expr)

Question Posted / guest

PLS-01471: The keyword DISTINCT must be present in a COUNT(DISTINCT sim_expr)..

Answer / guest

Cause: The keyword DISTINCT must be present in a
COUNT(DISTINCT sim_expr). Sect 5.8

Action: none

Please add more information about this Error

Is This Answer Correct ?

0 Yes

0 No

More Oracle Errors Interview Questions

ORA-16029: cannot change LOG_ARCHIVE_MIN_SUCCEED_DEST, no archive log destinations

ORA-24067: exceeded maximum number of subscribers for queue string

ORA-09835: addCallback: callback port is already in a set.

PCC-02448: Cannot specify a UCS2 variable in the NLS_NCHAR option

RMAN-00579: SCRIPT cannot be used with CMDFILE

SQL*Loader-00289: SQL string for column string occludes SQL string for column string.

ORA-26076: cannot set or reset value after direct path structure is allocated

SQL*Loader-00460: Column (string), form of use (number) does not match char set id of (number)

QSM-01089: an inline view in the query does not have a materialized view

TNS-00515: Connect failed because target host or object does not exist

SQL*Loader-00965: Error number disabling constraint string on table string

VID-00714: internal error

For more Oracle Errors Interview Questions Click Here