10g ordering varchar columns when containing numbers in front

I have an Oracle 10g DB and have a VARCHAR2 (2000 Character) column lets name it TEST which can contain numbers in front for example:

test
1test
3test

When I call "... order by TEST asc" or simply "... order by TEST"

I get the results ordered like

test
1test
3test

But I would like to get the results ordered like this:

1test
3test
test

So the numbered inserts first, is there a method to achieve this?

5
задан double-beep 2 February 2019 в 13:01
поделиться