This content has been marked as final. Show 2 replies
You can do this within the db by using the following order by clause
xxxx is your table name and data is the column name you want to sort.
select * from xxxx order by to_number(regexp_substr(data, '[0-9]+'))
Thanks a lot Timo :)
Its working perfectly.