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
9062 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

EXP-00052: error on row number of partition string

1 Answers

ORA-28102: policy does not exist

1 Answers

ORA-23603: STREAMS enqueue aborted due to low SGA

1 Answers

LFI-00140: Invalid option string were specified on input-output file.

1 Answers

DRG-11852: Can't Locate Remote Host

1 Answers

ORA-30133: reserved for future use

1 Answers

IMG-00806: invalid input image

1 Answers

ORA-02249: missing or invalid value for MAXLOGMEMBERS

1 Answers

ORA-37080: Advice requested for hierarchy with too many levels

1 Answers

NNF-01007: DCE long strings are not supported

1 Answers

ORA-30575: ConText Option not installed

1 Answers

DRG-13001: sub lexer and multi lexer must have the same owner

1 Answers

For more Oracle Errors Interview Questions Click Here