PLS-00423: ORDER BY item must be the number of a SELECT-list
expression



PLS-00423: ORDER BY item must be the number of a SELECT-list expression..

Answer / guest

Cause: A column alias was used in the ORDER BY clause of a
SELECT statement that uses a UNION, INTERSECT, or MINUS set
operator. This is not allowed. In such cases, expressions in
the ORDER BY clause must be unsigned integers that designate
the ordinal positions of select-list items.

Action: Change the alias in the ORDER BY clause to an
unsigned integer that designates the ordinal position of the
select item in question.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

LSX-00232: invalid unsigned long "~S"

1 Answers  


RMAN-05000: CONFIGURE AUXNAME required for datafile string

1 Answers  


ORA-26099: direct path context is already prepared

1 Answers  


ORA-00340: IO error processing online log string of thread string

2 Answers   ABC,


ORA-00052: maximum number of enqueue resources (string) exceeded

1 Answers  






ORA-15065: hash collision for diskgroup names 'string' and 'string'

1 Answers  


PLS-00521: ORDER methods must be declared with 1 (one) parameter in addition to (optional) SELF.

1 Answers  


ORA-16741: The destination parameter of standby "string" has the wrong syntax.

1 Answers  


PLS-00366: subtype of a NOT NULL type must also be NOT NULL

1 Answers  


ORA-09700: sclin: maximum number of latches exceeded

1 Answers  


ORA-16618: response document of size "string" bytes is too large

1 Answers  


PLS-00591: this feature is not supported in client-side programs

1 Answers  


Categories