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内自然数转成字符串类型编码排序问题解决(按照字符串排序)
最新推荐文章于 2022-09-05 22:47:04 发布