oracle之字母数字混合排序

字母数字混合排序

select *
from O_OPER
order by replace(translate(OPER_ID, '0123456789', '#'), '#', '') desc,
to_number(replace(OPER_ID, replace(translate(OPER_ID, '0123456789', '#'), '#', ''), '')) desc;