Natural Sort Order
795462Sep 15 2010 — edited Sep 17 2010I have a View created in JDeveloper to perform a query on a database view. The query works fine but I'm having issues with the sort. I use the Order By field to select the columns for sorting however I'm not getting the expected results.
My Data looks like this:
1
10
2
3
I need it to look like this:
1
2
3
10
Is there a way to correct this is JDeveloper or do I need to try and correct this on the view created in the Database? Any help would be greatly appreciated.
Thanks, scopley