Organizational Research By

Surprising Reserch Topic

oracle how can i implement a natural order by in a sql query


oracle how can i implement a natural order by in a sql query  using -'sql,oracle'

e.g,

foo1
foo2
foo10
foo100


rather than

foo1
foo10
foo100
foo2


Update: not interested in coding the sort myself (although that's interesting in its own right), but having the database to do the sort for me.
    

asked Oct 3, 2015 by okesh.badhiye
0 votes
45 views



Related Hot Questions

5 Answers

0 votes
NULL
answered Oct 3, 2015 by balvant maurya
0 votes
NULL
answered Oct 3, 2015 by vijayshukla80
0 votes
NULL
answered Oct 3, 2015 by jekbishnoi
0 votes
NULL
answered Oct 3, 2015 by ankitarajoria4
0 votes
NULL
answered Oct 3, 2015 by yogeshplv

...