Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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



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

Post New Answer

More Oracle Errors Interview Questions

QSM-02052: subquery using a select list in mv

1 Answers  


ORA-01969: You must specify RESETLOGS or NORESETLOGS

1 Answers  


ORA-29911: null scan context returned by ODCIIndexStart() routine

1 Answers  


ORA-01227: log string is inconsistent with other logs

1 Answers  


TNS-00553: read failed

1 Answers  






LPX-00410: unable to resolve the variable reference

1 Answers  


ORA-12831: Must COMMIT or ROLLBACK after executing INSERT with APPEND hint

1 Answers  


ORA-00100: no data found

1 Answers  


SQL*Loader-00416: SDF clause for field string in table string references a non existent field.

1 Answers  


ORA-22322: error table "string"."string" has incorrect structure

1 Answers  


PLS-00543: a PLSQL Table may not contain a nested table type or VARRAY.

1 Answers  


ORA-07582: spstp: ORA_SID has illegal value

1 Answers  






Categories