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 |
LSX-00232: invalid unsigned long "~S"
RMAN-05000: CONFIGURE AUXNAME required for datafile string
ORA-26099: direct path context is already prepared
ORA-00340: IO error processing online log string of thread string
ORA-00052: maximum number of enqueue resources (string) exceeded
ORA-15065: hash collision for diskgroup names 'string' and 'string'
PLS-00521: ORDER methods must be declared with 1 (one) parameter in addition to (optional) SELF.
ORA-16741: The destination parameter of standby "string" has the wrong syntax.
PLS-00366: subtype of a NOT NULL type must also be NOT NULL
ORA-09700: sclin: maximum number of latches exceeded
ORA-16618: response document of size "string" bytes is too large
PLS-00591: this feature is not supported in client-side programs