| |
GeekInterview.com > Interview Questions > Oracle > Data Access
| Print | |
Question: There is a field of type character in the table, but we are storing numeric values like (Roll number) in this field, so if we want to sort the field (in java) according to numbers.How?
Answer: by creating a function for sorting in the front end(guessing, i am not sure. plz answer it) |
| December 12, 2006 12:40:12 |
#3 |
| rampratap409 |
Member Since: September 2006 Total Comments: 108 |
RE: There is a field of type character in the table, b...
|
use: select to_number(rollnumber) from tname order by to_number(rollnumber); or select rollnumber from tname order by to_number(rollnumber); convert the value to integer in java |
| |
Back To Question | |
