Oracle: How to sort mixed alphanumeric in a logical numeric order (while avoiding the ORA-01722 erro

[sloot]

I added a new select at the bottom that deals with decimal numbers

create table sort_test

Comments

[amaena]

your oracle tags are most awesome :)

my unix shit is in chicks_dig_unix

[sloot]

tags are the way and the truth and the light

[tigertosser]

You should post this to dork ottawa. :P

Also, I hate oracle. I don't understand what it's doing with it's database structure. It doesn't seem logical. What does it need users for? and how do I un-pack a sample database into it without getting errors half the time?

[sloot]

it needs users for security and authentication. You don't want just anybody to be able to modify those payroll records do you?

And fixing the unpacking errors would depend on what you were doing and what the errors were