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

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00423：ORDER BY项必须是SELECT-list表达式的编号,
.原因：在使用UNION，INTERSECT或MINUS集合运算符的SELECT语句的ORDER BY子句中使用列别名。这是不允许的。在这种情况下，ORDER BY子句中的表达式必须是无符号整数，它们指定选择列表项的顺序位置。,
.操作：将ORDER BY子句中的别名更改为无符号整数，该整数指定有问题的选择项的顺序位置。,
.

aiaiDBA

13718043309

010-86462881

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

1 个回答

相似问题