SELECT
"SUBSTR" (
"TO_CHAR" (
"TO_NUMBER" (X.ORDER_NUM) + 1000
),
2,
3
)
FROM
(
SELECT DISTINCT
ORDER_NUM
FROM
"SJCK"."FACT_LINE_ANALY_FINANCE"
ORDER BY
"TO_NUMBER" (ORDER_NUM) + 1000
) X
1000内自然数转成字符串类型编码排序问题解决(按照字符串排序)
最新推荐文章于 2024-02-04 16:13:11 发布