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?

By creating a function for sorting in the front end(guessing, i am not sure. plz answer it)

sanyogkesar
Profile Answers by sanyogkesar Questions by sanyogkesar
Nov 8th, 2005
4
2182

Showing Answers 1 - 4 of 4 Answers

e.gomathi

Feb 7th, 2006

select to_number() from order by ;

e.gomathi

Feb 7th, 2006

select to_number(rollnumber) from tname order by rollnumber

rampratap409
Profile Answers by rampratap409 Questions by rampratap409

Dec 4th, 2006

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

sateesh240
Profile Answers by sateesh240

May 7th, 2009

Read character column into a PL/SQL table of numeric data type by converting to number, pass the PL/SQL table to JavaScript as a parameter, this is one way..