Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Natural Sort Order

795462Sep 15 2010 — edited Sep 17 2010
I 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 15 2010
Added on Sep 15 2010
9 comments
3,441 views