Natural sort
From: Álvaro G. Vicario <alvaroNOSPAMTHANKS_at_demogracia.com>
Date: Fri, 03 Oct 2008 09:51:48 +0200
Message-ID: <gc4ivc$1ne$1@huron.algomas.org>
Date: Fri, 03 Oct 2008 09:51:48 +0200
Message-ID: <gc4ivc$1ne$1@huron.algomas.org>
Does Oracle 10g have a so called "natural sort" feature? E.g.:
foo1 foo2 foo10 foo100
... rather than:
foo1 foo10 foo100 foo2
Docs says I can use NLSSORT() in ORDER BY clauses but available values for NLS_SORT do not seem to cover this case. I Google for "natural sort in oracle" and all I get is how to do it in C++ and PHP...
--
- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
- Mi sitio sobre programación web: http://bits.demogracia.com
- Mi web de humor al baño María: http://www.demogracia.com --