QSM-02183: Expression to enable PCT not in PARTITION BY of analytic function or

QSM-02183: Expression to enable PCT not in PARTITION BY of
analytic function or SPREADSHEET

Question Posted / guest

1 Answers
9153 Views
I also Faced
E-Mail Answers

QSM-02183: Expression to enable PCT not in PARTITION BY of analytic function or SPREADSHEET..

Answer / guest

Cause: The capability in question is not supported when the
expression is not in the PARTITION BY clause

Action: Change the query so that the expression is in the
PARTITION BY

Please add more information about this Error

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-02441: Cannot drop nonexistent primary key

1 Answers

ORA-27371: jobs of type EXECUTABLE are not supported on this platform

1 Answers

SQL*Loader-00500: Unable to open file (string)

1 Answers

TNS-01109: Listener password encryption failed

1 Answers

ORA-36872: (XSTFDSC02) Column type specifier cannot be used when the table function data type is specified.

1 Answers

ORA-31102: Already locked in exclusive mode. Cannot add lock.

1 Answers

ORA-30053: invalid upper limit snapshot expression

1 Answers

ORA-25469: data not specified for alias: string column name: string

1 Answers

PCC-02373: Invalid declaration in EXEC SQL DECLARE section

1 Answers

ORA-30199: reserved for future use

1 Answers

CLSS-00099: logfile open failed for string, err string

1 Answers

ORA-01212: MAXLOGMEMBERS may not exceed string

1 Answers

For more Oracle Errors Interview Questions Click Here