Oracle 点滴
order by (case when upper( SUBSTR(t.ids, INSTR(t.ids,'-',1, 2)+1, INSTR(t.ids,'-',1, 3)-INSTR(t.ids,'-',1, 2)-1)) = lower(SUBSTR(t.ids, INSTR(t.ids,'-',1, 2)+1, INSTR(t.ids,'-',1, 3)-INSTR(t.ids,'-',1, 2)-1))--大小写一样表示数字then LPAD( SUBSTR(t.ids, INSTR(t.ids,'-',1, 2)+1, INSTR(t.ids,'-',1, 3)-INSTR(t.ids,'-',1, 2)-1),8)
else
RPAD( SUBSTR(t.ids, INSTR(t.ids,'-',1, 2)+1, INSTR(t.ids,'-',1, 3)-INSTR(t.ids,'-',1, 2)-1),8)
end
)
页:
[1]